Yesterday, I was performing optimization task on MySQL tables manually and mistake.. oh my mistake, I corrupted the database. One command was enough!! And I even didn't backup my database.

Thanks to DreamHost . They have automatic backup and I was able to restore within 5-10 minutes but 5-10 minutes were enough for me to stressed out.

Lesson Learned...

• Always create backup before doing anything with MySQL
• Better yet, do not directly operate on MySQL
• Have local copy of MySQL and play with that first, create script. Rerun script on local, double check for error... and so on.