[mythtv-users] upgrading MySQL

[Michael T. Dean]

On 04/03/2009 02:09 AM, David Brodbeck wrote:
> sonofzev wrote:
>> Also can a backup (not the actual binary files) of a database be 
>> restored on
>> another system? Does it have to be the same version of MySQL? Can it 
>> be a 64 bit
>> db if the original was 32 bit? 
>
> If it's a backup made with mysqldump, yes, you should be able to 
> restore it on a different version of MySQL.  A mysqldump backup is 
> just a series of SQL statements that will recreate the database; it 
> doesn't care about versions or word size or endianness.
>
> It's only the binary files you have to be careful about moving.

Right, and the easiest way to get a good backup is 
http://www.mythtv.org/wiki/Database_Backup_and_Restore .  Then, restore 
/after/ running mc.sql ( 
http://www.mythtv.org/wiki/Database_Backup_and_Restore#Database_Restore 
) but /before/ running any MythTV programs on the new system) with 
http://www.mythtv.org/wiki/Database_Backup_and_Restore#Full_restore_of_a_specific_backup_file 
or 
http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup.2C_including_plugin_data 
.

(Note that the full restore and the partial restore with plugin data 
both work without additional patches.)

Mike