Are you using only MyISAM or InnoDB tables? With the InnoDB tables you have the possibility of data not yet being committed. Either way, unless you can flush, lock and perform the dump and transfer all in one swoop you risk incosistency using this method.
-----Original Message----- From: Ben Ricker To: [EMAIL PROTECTED] Sent: 5/18/04 2:14 PM Subject: Doing MySQl DB File backups I am working on doing backups of a MySQl server that is running approx 20 databases. Our failover is to do a nightly scp of all /data directory from one server to the backup. I know that replication or mysqldump would be best, but I do not want to get into that. My question is what is the best way to make sure that the files that are transferred are the latest data at the time of the scp? Does MySQL write to the data files when changes are made? Are they buffered? I though that a "mysqladmin refresh" before doing the scp might make a difference but I cannot verify it. Can someone enlighten me on this? Thanks, Ben Ricker ----------------------------------------- CONFIDENTIALITY NOTICE This e-mail message and any attachments are only for the use of the intended recipient and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient, any disclosure, distribution or other use of this e-mail message or attachments is prohibited. If you have received this e-mail message in error, please delete and notify the sender immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
