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
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