[Box Backup] Box saved my a**/day
Sat, 11 Feb 2006 15:13:42 +0100
> Be wary of relying on direct backups of databases (for any DBMS). If
> it's being modified as the backup is done, there's no guarantee (even
> with journalling) that the results will be usable.
> For MySQL, the simplest procedure is to run the following in a cron
> job, and then back that file up instead.
I am well aware of this and we do have consistent backups as well but
in this case the box backup the specific MyISAM files needed were indeed
consistent (call it luck) and was the one with the least data loss. And that
was really great for us!