PapaScott I like big blogs and I cannot lie! 🐘

You Don't Want to Need to Know

You don't really want to need to know how to recover from mysql crashes, be they the result of natural or man-made disasters. It's good to know that you can, but it's better to avoid the disasters in the first place. You'd rather not have to find the previous snapshot, convert the subsequent bin logs to SQL, edit a 200 MB file to delete the bad SQL statements, pipe those commands to the mysql client to update the snapshot, re-edit the SQL every time it gets stuck on a temporary table, and hope that everything turns out OK.

The chances are good that everything will turn out OK, but you really don't want to have to find out.

comments powered by Disqus