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