New answers tagged crash
No, rollbacks cannot be done in the background. Both that and the double write checks have to be done before accepting connections again (meaning that if you kill it, you will have to start again on restart). REDO process, however, can and is done in the background. What you can do is kill mysql (again) and restart it skipping that step: /etc/init.d/mysqld ...
Try to recover the database using force_recovery option 4 or higher but this can permanently corrupt the database as options higher than this will try to commit transactions which wasn't completed. If the recovery worked, and you wont like to recover each database by hand then start MySQL by skipping grant tables and dump all the databases. Install a fresh ...
I just had the same problem, this was fixed by issuing a command, assuming mysql data dir is on /var/lib/mysql/mysql myisamchk -q -r /var/lib/mysql/mysql/proc Source : http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html
Top 50 recent answers are included