Mailing List Archive

On Friday 18 July 2003 09:33 pm, JOna wrote:
> I have some 50 recordings made with Mythtv-cvs from early June.
> After compiling the current cvs (July 18) I noticed that "recorded"
> -table has now a different format.

A couple of columns were added to the recorded table. Nothing incompatible.

> Is there any way I can add my old nuv-files to the current database?
> Filenames like "0_20030601095100_20030601105100.nuv".

Why'd you take them out of the database in the first place?

> Can I rename the files and add them to mysql with the names I prefer?
> What is the procedure?

Filenames aren't stored in the database, they're generated at runtime from the
chanid, starttime, and endtime of the program.

Isaac
_______________________________________________
mythtv-users mailing list
mythtv-users@snowman.net
http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users

> 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

_______________________________________________
mythtv-users mailing list
mythtv-users@snowman.net
http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users

On Friday, July 18, 2003, at 06:33 PM, JOna wrote:

> I have some 50 recordings made with Mythtv-cvs from early June.
> After compiling the current cvs (July 18) I noticed that "recorded"
> -table has now a different format.
>

there is usually an upgrade path that allows you to keep your database
intact. Use the appropriate .sql update files in the database
directory.

> Is there any way I can add my old nuv-files to the current database?
> Filenames like "0_20030601095100_20030601105100.nuv".
>
> Can I rename the files and add them to mysql with the names I prefer?
> What is the procedure?

myth.rebuilddatabase.pl within the contrib directory might be what
you are looking for. It hasn't been updated in a long time so I'm not
sure it still works. But I tried it a few months ago and it worked well.

_______________________________________________
mythtv-users mailing list
mythtv-users@snowman.net
http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users

I found out that after inserting the files I had to run mythcommflag
to avoid "out of sync" problems after FFW/Rewind. For the example
that I used in my previous post the commands are:

mythcommflag --chanid 8 --starttime 20030718010000
mythcommflag --chanid 8 --starttime 20030718020000

JOna

*

mini-HOWTO add mpg-files to mythtv
===========================

Something that I have recorded with "cat /dev/video0 >somefile.mpg"

1) rename the file:

mv somefile.mpg 8_20030718010000_20030718010500.nuv

where:
8 = chanid
20030718010000 = starttime
20030718010500 = endtime

2) create addfiles.sql with the following:

connect mythconverg;
INSERT INTO recorded VALUES
(8,20030718010000,20030718010500,'Title','Subtitle',' ',
NULL,'localhost.localdomain',NULL,0,NULL,0);

3) insert data to mysql:

mysql -u mythtv -p < addfiles.sql

4) run mythcommflag for the added file(s):

mythcommflag --chanid 8 --starttime 20030718010000

_______________________________________________
mythtv-users mailing list
mythtv-users@snowman.net
http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users