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
],
rs.com '[EMAIL PROTECTED] ' [EMAIL
PROTECTED]
cc:
05/18/2004 02:56 Subject: RE: Doing MySQl DB File
backups
Ben Ricker wrote:
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