On Thursday, June 3, 2004, 8:14:00 AM, Victor wrote: VP> If you choose to copy the files I would ensure that you are getting the VP> innodb binary logs as well if they do not exists in the mysql data VP> directory. The innodb backup tool or even mysqldump may provide a more VP> consistent snapshot.
If I might add $0.02 here... It has been my experience that mysqldump is the best solution. * The data is portable to alternate installs if needed (including changes in memory configurations which can improve performance...) * The output of mysqldump is typically much smaller when compressed than the raw data files. This invariably makes the operation faster and more efficient. Best, _M -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]