MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

MySQL crashed, wont boot unless innodb force recovery mode 3
Posted by: Dean Woodford
Date: February 18, 2015 11:15AM

Hi,

We have some databases on a mysql 5.1 server. This crashed, and when trying to start the mysql service, it does not start.

If we edit the my.ini file to set the innodb recovery mode to 3, it will start. This put the database back online, but it fails to add new records.

We tried to drop all the databases and restart without the forced recovery, but this still fails.

Can anyone help with a solution on how to restore the database so it is operational, even as a fresh instance as we have a backup.sql file with all of our data, we just cannot get the service to start without forced recovery mode 3 enabled.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MySQL crashed, wont boot unless innodb force recovery mode 3
2204
Dean Woodford
February 18, 2015 11:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.