Tony Abernethy wrote:
With the usual caveats of "Your Mileage May Vary", this may give you an
idea of how far you can push things and get away with it.
In practice, I back up production MySQL databases when they are running.
Not that big a deal.
Some notes on improving the odds (of getting awa
With
the usual caveats of "Your Mileage May Vary", this may give you an idea of how
far you can push things and get away with it.
In
practice, I back up production MySQL databases when they are running. Not that
big a deal.
Some
notes on improving the odds (of getting away with it):
One
Mickaël,
In general one should not backup databases while they are running.
the safest way to backup any database is to switch it off (usually called
coldmode) and to run in your case rsync.
another way is th run the normal mysql backup commands to a local disk
location and after the mysql ba
