On Thursday 13 December 2007 11:56, David C. Rankin wrote:
Randall R Schulz wrote:
On Thursday 13 December 2007 08:12, David C. Rankin wrote:
...
Even quicker
cp -a /mnt/var/lib/mysql /var/lib/
This is not generally a good idea. If you're using the older MySQL file format (called MyISAM), it might work. If you're using the newer InnoDB file format (the only one that supports all of MySQL's features, by the way), then simply copying files is susceptible to failure.
Dump and import is the right way, even if it's not as fast.
Cheers, David
Ah, true, but 10.2 - 10.3, both with mysql 5.x should be OK with both MyISAM and InnoDB files. I wouldn't recommend a straight copy of something as far apart as 10.0 -> 10.3.
The point is that InnoDB files per se are intrinsically non-portable in the way MyISAM files are. It has less to do with versions than it does to do with the way InnoDB integrates multiple tables and databases into a single file (or set of files).
... David C. Rankin
Randall Schulz -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org