Are you dropping then recreating the tables and data, or just doing a diff between what's on the backup and what's in the zip file and updating the difference?
I've been doing a drop on the tables and recreating them and it seems to work ok. > -----Original Message----- > From: > [EMAIL PROTECTED] > om > [mailto:[EMAIL PROTECTED] > .mysql.com] On Behalf Of Andrew Loughe > Sent: Wednesday, 5 May 2004 1:09 p.m. > To: [EMAIL PROTECTED] > Subject: MySQL hotcopy problem (poor man's replication) > > > Hello, > > MySQL version: 3.23.58 > > Each week I make a hotcopy of numerous database files. > I tar them and gzip them, and move them to an archive machine. > > I then use a second machine to read from the archive, untar and ungzip > the files, and presto! I have exact copies of my databases running on > a backup server. > > I even prove that the MyISAM files are the same using MD5 checksums. > > Then why do I get different results from the queries? > > The copied tables are sometimes missing weeks worth of data, even > though the MyISAM files appear to be identical. Strange, eh!? > > -Andy > > -- > Andrew Loughe ===================================================== > NOAA/OAR/FSL/AD R/FS5 | email: [EMAIL PROTECTED] > 325 Broadway | wwweb: www-ad.fsl.noaa.gov/users/loughe > Boulder, CO 80305-3328 | phone: 303-497-6211 fax: 303-497-6301 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > > ------------------------------------------------------------------------------ "This communication, including any attachments, is confidential. If you are not the intended recipient, you should not read it - please contact me immediately, destroy it, and do not copy or use any part of this communication or disclose anything about it. Thank you. Please note that this communication does not designate an information system for the purposes of the Electronic Transactions Act 2002." ------------------------------------------------------------------------------ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
