what not to do in MySQL... and how to pick up the pieces

note to self... do NOT kill mysql processes from phpmyadmin's control panel and force mysql to quit. Bad things happen. In this case, mysql wouldnt start again. InnoDB's indexes, binary logs, etc. were all out of sync. The 20 page log explaining all the ways the DB couldn't start is …

more ...