[mythtv-users] Nuvexport from 0.14 to 0.15

[Steve Frank]

> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org 
> [mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Bruce Markey
> Sent: Tuesday, June 01, 2004 4:02 PM
> To: Discussion about mythtv
> Subject: Re: [mythtv-users] Nuvexport from 0.14 to 0.15
> 
> Steve Frank wrote:
> > Sadly, I'm already up and running nicely in 0.15 without any 
> > additional stuff. I suppose I could upgrade the old machine 
> from 0.14 
> > to 0.15 and go from there...  I was looking for an easy answer. :-)
> 
> If you have new database and old recordings you just need to 
> dump and restore the data for the recorded shows. NOTE: if 
> you are moving the files to a new host, you must change the 
> hostname in your restore file in order for the new server to 
> find the files on the given hostname.
> 
> -------8<---------8<-----
> Make a backup of your database right now:
> 
> http://www.mythtv.org/docs/mythtv-HOWTO-21.html#ss21.5
> 
> Look in your file as see that it is thousands of lines of 
> readable text. Once you know up have a good current backup, 
> then continue.
> 
> After you have and good backup, read the rest of this message 
> and decided you want to do this, go on to:
> 
> http://www.mythtv.org/docs/mythtv-HOWTO-21.html#ss21.5
> 
> Then:
> 
> http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.4
> 
> When you first run setup, mythbackend or mythfrontend, all 
> the tables will be created for your new database. Therefore, 
> you don't need any of the CREATE TABLE statement but only 
> need the INSERT INTO statements for the tables you need to restore.
> 
> Restore the information from "record' (the titles you've 
> chosen to record), 'recorded' (the descriptive info for your 
> recording), 'oldrecorded' (for finding duplicates that you've 
> recorded previously) and 'recordedmarkup' (keyframe seek 
> info, commercial skipping, etc).
> 
> grep "INSERT INTO record "   mythtv_backup.sql > restore.sql
> grep "INSERT INTO recorded " mythtv_backup.sql >> restore.sql 
> grep "INSERT INTO oldrecorded " mythtv_backup.sql >> 
> restore.sql grep "INSERT INTO recordedmarkup " 
> mythtv_backup.sql >> restore.sql
> 
> Note the space after the table name and the ">>" to append to 
> the file for all but the first grep. "recordedmarkup" is huge 
> and may be hundreds of thousands of lines if you had lots of 
> hours of recordings.
> 
> If your hostname has changed, bring up restore.sql in an 
> editor to search and replace your old hostname with the new 
> one being careful to not replace if your old hostname appears 
> in a show's title or description ;-).
> 

Ha ha ha, I laughed about this one. The box is hostname "mythtvblack" so
that would be an odd thing to see in the middle of a show title. :-)


> Once your file is ready to go:
> 
> $ mysql -u mythtv -pmythtv mythconverg < restore.sql
> 
> If something goes terribly wrong you can:
> 
> $ mysql -u mythtv -pmythtv mythconverg
> mysql> delete from record
> mysql> delete from recorded
> mysql> delete from oldrecorded
> mysql> delete from recordedmarkup
> 
> then start over.
> 
> -------8<---------8<-----
> 
> --  bjm


Thanks, Bruce. I understand and appreciate the concise answer.

Steve