i don't think it will. the safest thing to do is run a php or perl script that basically does this:
I believe all the tables are MyISAM...the DB is 3.2.x.
I know there will be an inconsistency as we only do nightly backups; any transactions that occur before the scp will not be there. If we failover before the backup, we can have up to 24 hours of data missing.
I am concerned that we will have MORE then 24 hours data missing because the DB may not (or may) write the data that has changed to the data files.
Do you knif the mysqladmin refresh will force a write to the DB data files?
connect to mysql execute on mysql: FLUSH TABLES WITH READ LOCK; scp files exit
this way you are guaranteed that the tables are flushed and won't have any new inserts or updates done while the scp is in process.
-jsd-
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
