Re: MySQL hotcopy problem (poor man's replication)

2004-05-05 Thread Sasha Pachev
Andrew Loughe wrote: 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 database

Re: MySQL hotcopy problem (poor man's replication)

2004-05-04 Thread Paul DuBois
At 19:08 -0600 5/4/04, Andrew Loughe wrote: 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 exac

RE: MySQL hotcopy problem (poor man's replication)

2004-05-04 Thread Chris Hellberg
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 PROTECTE