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
an
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 runn
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
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 bes
