[mythtv-users] How to add old nuv-files to recorded?
JOna
jblistat at sll.fi
Sat Jul 19 08:54:51 EDT 2003
> Isaac Richards wrote:
> A couple of columns were added to the recorded table. Nothing
> incompatible.
OK. I added those new colums to sql and got my recordings back
into database.
> Filenames aren't stored in the database, they're generated at runtime from
> the chanid, starttime, and endtime of the program.
Thanks! With this info I was able to add also videos from other sources
to my database! Just rename the nuv/mpeg files to something like:
"8_20030718010000_20030718010500.nuv"
"8_20030718020000_20030718020500.nuv"
etc.
and insert corresponding colums to mysql, by creating addfiles.sql:
connect mythconverg;
INSERT INTO recorded VALUES
(8,20030718010000,20030718010500,'Title','Subtitle','
',NULL,'localhost.localdomain',NULL,0,NULL,0);
INSERT INTO recorded VALUES
(8,20030718020000,20030718020500,'Tile','Subtitle','
',NULL,'localhost.localdomain',NULL,0,NULL,0);
etc.
and running mysql -u mythtv -p < addfiles.sql
JOna
More information about the mythtv-users
mailing list