[mythtv-users] upgrading MySQL
Michael T. Dean
mtdean at thirdcontact.com
Fri Apr 3 14:15:03 UTC 2009
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
More information about the mythtv-users
mailing list