Mailing List Archive: two questions, migrating backend, general record

two questions, migrating backend, general record

May 5, 2003, 8:04 AM

Post #1 of 4 (1200 views)

Two questions for the mythtv masters:

I setup a new box as the master backend, can I just move the files from
the old master and add then entries to the mysql database and have them
work?

Is there a general record for mythtv? For example I have several dozen
home movie tapes that I'd like to put under mythtv control. The easiest
way would be to hook a vcr up to the composite in on the capture card
and tell mythtv to record and give it the info for the database. From
what I've seen you can only record via the EPG. Am I wrong? Is there a
nice general start record, stop record, and use this label method?

Thanks,

Eric

Re: two questions, migrating backend, general record [ In reply to ]

linux.news at bucksch

May 5, 2003, 10:01 AM

Post #2 of 4 (1134 views)

Permalink

Eric Estabrooks wrote:

> Is there a nice general start record, stop record, and use this label
> method?

Are you using 0.8? CVS (with 0.9 coming out soon) has a "manual record"
feature.

Re: two questions, migrating backend, general record [ In reply to ]

eric+mythtv at urbanrage

May 5, 2003, 10:24 AM

Post #3 of 4 (1145 views)

Permalink

Ben Bucksch wrote:

> Eric Estabrooks wrote:
>
>> Is there a nice general start record, stop record, and use this label
>> method?
>
>
> Are you using 0.8? CVS (with 0.9 coming out soon) has a "manual
> record" feature.

I went the deb package route so I'm using 0.8, didn't feel like braving
the manual install after I found out I could just
apt-get install mythtv and have it all setup (except for running
mythtv-setup).

That'll be very nice, when is 0.9 scheduled to come out?

Eric

Re: two questions, migrating backend, general record [ In reply to ]

bjm at lvcm

May 6, 2003, 2:39 AM

Post #4 of 4 (1139 views)

Permalink

Eric Estabrooks wrote:
> Two questions for the mythtv masters:
>
> I setup a new box as the master backend, can I just move the files from
> the old master and add then entries to the mysql database and have them
> work?

I didn't see any masters answer this so here's my advice =).

First, backup your database.

http://www.mythtv.org/docs/mythtv-HOWTO-19.html#ss19.6

The information MythTV uses to find the files is in the
"recorded" table which includes a column for "hostname".
Copy the lines from your database backup file that begin
with "INSERT INTO recorded VALUES" into a separate file.
Search and replace the old hostname with the new hostname
then insert into your new database:

mysql -u mythtv -pmythtv mythconverg < tmpfile

That's all you'll need to playback the copies of your
old recordings on your new system.

If you want instant commercial skipping to work you can
also copy all of the "INSERT INTO recordedmarkup " lines.

Also, if you want to keep the list of shows you like to
record, copy the "INSERT INTO record " lines.

-- bjm