David Ulevitch wrote:
On Jul 12, 2005, at 6:15 AM, gerald_clark wrote:
Nightly backup and binlogs can take you to any point in the day.
I failed to make my entire point clear then. That's true.
But when someone does the "oh fsck, I think I just ran a catastrophic
query on our production database" we would now have a running system
in place that hasn't yet processed that query that can be compared
against the real thing within seconds or minutes to see what the
damage is and/or just try to repair.
When you restore a 20gig+ database from binlogs and try to find a
point-in-time, it takes more than seconds/minutes. You have tried a
restore right??? :)
-davidu
Yes, we do restores and run bin logs for our customers whenever necessary.
You can have more than 1 binlog/day so you don't have to edit monster
log files.
How are you going 'repair' deleted data without a restore?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
