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. Unless you have a monster database containing gigabytes of data the cost of a nightly archival should be far less than the cost of your time doing a four month restore of the data. Do the math and show your boss if he needs any convincing. The numbers should speak for themselves.
John Griffin -----Original Message----- From: Mark [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 11:14 PM To: [EMAIL PROTECTED] Subject: rollback a table? 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 it with, stopping at the one that hosed my data. Anyway, it was a project and it seems like there should be a better way. Is there? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
