[mythtv-users] Upgrade Old system

[Michael T. Dean]

On 01/18/2010 03:21 PM, Vincent Jorrand wrote:
>> On Mon, Jan 18, 2010 at 11:43 AM, Ken Smith wrote:
>>     
>>> This is probably a theme which has been asked about a few times but I just want to make sure I'm clear
>>>
>>> I have an ancient FC6 Myth 0.20 system built from RPM's in the UK with two DVB and a analog capture card.
>>>
>>> My plan is to migrate the data and the cards to a new box with a dual core 64 bit CPU and Centos. With any luck I can put in a DVB-S card and get UK HD. FC moves too fast for this near production system, and I don't want to re-install the box every few months.
>>>
>>> So what I hope I can do in set up the current version of Myth on the Centos system and move both the original database and files over to it. Am I right that the new Myth System will upgrade the database?
>>>
>>> If not all I really want to keep are tables about the existing recordings and if possible the recording schedules.
>>>
>>> Sorry if this has been asked about 1000 times before
>>>       
>> Just backup the database and put the recordings in the same path they were in on the old machine.  Restore the DB,

Exactly.  And make sure you do a full backup and a full restore (
http://www.mythtv.org/wiki/Database_Backup_and_Restore and/or
http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5 ).  You do /not/
want to do a "partial" restore.

>>  then install the Myth packages (or compile if that's your thing)
>> and Myth should upgrade the DB schema for you. You may have to go from .20 to .21 then .22, I don't know how Myth handles that.

No need.  You can upgrade from (IIRC) 0.11 all the way to 0.22 without
any intermediate versions.  If you were running 0.08, though...  ;)

>>  I'd use the backup and try going straight to .22. If
>> it doesn't work, you can always restore and try .21. The wiki has the commands for backing up and restoring the database, just mysqldump. 
> You may also save yourself some hassles if you use the same name for
> the system and the same IP address, otherwise you will have to mess
> with the settings table.
>   

Very good advice.

Mike