Yes,
Back up your data every night. Then you will only have to perform a single simple
restore instead of rebuilding from four months ago. I know that this sounds like a
smart ass reply but I am serious. Disk space is cheap. CD's are cheap. Other media
like DVDs are getting cheaper every day.
Mark wrote:
Hi,
Something bad happened the other day, a query hosed all the data in
my table, but luckily I had an original dump of the table from 4
months ago and binlogs from then on. I had to load the original table
into a separate db and then grep through the binlogs for queries to
update
