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]
