All hail MySQL backups
We went through a nightmare today morning 11 AM. While deleting a few invalid entries from our data, we accidentally wiped our User table! Yup! clean slate! All our users since we started gone blank!! We take backups of our database three times everyday, and the last backup from 10 AM had data for all but 2 users. We’re back to normal now, but unfortunately we don’t have any data on those two users now. Our apologies to them, hope they read this and come back again :).
Lesson learnt - no matter how much RAID you have, how many MySql slaves you have, always, always back up your DB. We keep backup copies of our DB for 3 times a day for last 7 days, 1 time a week for last 4 weeks, and monthly backups. We don’t have transaction logging for InnoDB turned on though, could that have saved the day in case of such accidental updates? Need to check that.
5 comments December 15th, 2007