[mythtv-users] upgrading MySQL
gull at gull.us
Fri Apr 3 06:09:08 UTC 2009
sonofzev at iinet.net.au 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.
More information about the mythtv-users