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
Randall Schulz -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org