[Box Backup] Box saved my a**/day
Sat, 11 Feb 2006 13:14:23 +0100
Yesterday (friday) a colleague of mine discovered he had
overwritten a customer database (in MySQL) with a month
old test data. Disregading from the fact that this should not
be able to happen we were happy (as happy as can be in
that situation) to discover that the files (around 50 MyISAM
file) were relatively easy to recover via bbackupquery since
old revisions of files are kept in the store. The latest versions
were not usable but a generation back was.
It required a bit of scripting (and maybe gave some ideas of
possible bbackupquery interface improvements) but in the
end really save the day! Only a couple of vital transactions
wre lost and could be re-created manually.
Many, many thanks to Ben (and "all") for that!