[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