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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
