Randall R Schulz wrote: > On Thursday 13 December 2007 08:12, David C. Rankin wrote: >> Dave Howorth wrote: >>> Carl Hartung wrote: >>>> ... >>>> >>>> What's the fastest easiest 'no-frills' commandline solution? >>>> (assume prior '/' is mounted under '/mnt/') :-) >>> mysqldump => mysqlimport >>> start at <http://dev.mysql.com/doc> >>> >>> Cheers, Dave >> 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. Good point Randall -- David C. Rankin, J.D., P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
