You Don't Want to Need to Know27 Apr 2005
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.