Mailing List Archive: MythTV: Users

How to add old nuv-files to recorded?

Index | Next | Previous | View Threaded

jblistat at sll

Jul 18, 2003, 6:33 PM

Post #1 of 5 (1103 views)
Permalink

How to add old nuv-files to recorded?

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.

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?

JOna

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

ijr at po

Jul 18, 2003, 6:55 PM

Post #2 of 5 (1053 views)
Permalink

Re: How to add old nuv-files to recorded? [In reply to]

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 [at] snowman
http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users

jblistat at sll

Jul 18, 2003, 9:54 PM

Post #3 of 5 (1050 views)
Permalink

Re: How to add old nuv-files to recorded? [In reply to]

> 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 [at] snowman
http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users

cedarmckay at mac

Jul 18, 2003, 11:22 PM

Post #4 of 5 (1051 views)
Permalink

Re: How to add old nuv-files to recorded? [In reply to]

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 [at] snowman
http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users

jblistat at sll

Jul 19, 2003, 8:28 AM

Post #5 of 5 (1086 views)
Permalink

Re: How to add old nuv-files to recorded? [In reply to]

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 [at] snowman
http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads