Re:Backing up live MySQL Databases

2005-06-16 Thread mfatene
hi, there will not be a lot of paying backup tools if just copying files is OK. You can't because active transactions change some files checkpoint, then you copied files are not at the same checkpoint state, and you can't use the copy for a restore. The only way is to lock all the tables if you wa

Re:Backing up live MySQL Databases

2005-06-16 Thread Ashley M. Kirchner
With all this discussion going on about the best way to backup MySQL data, I have a question: Is there anything wrong with simply copying the db files when you're backing up, as opposed to doing a full shutdown of the server (regardless of whether it's a master or slave) and then doing a