MySQL is not starting and giving innodb corrupt errors. How can I fix this? Print

0

If MySQL is not starting and giving innodb corrupt errors in /var/lib/mysql/$HOSTNAME.err you can do the following to attempt to get MySQL to start:

* check the MySQL error log:

tail -n30 /var/lib/mysql/$HOSTNAME.err

* Edit /etc/my.cnf and add the line:

innodb_force_recovery = 4

* Restart MySQL:

service mysql restart

* Edit /etc/my.cnf and remove the line:

innodb_force_recovery = 4

* Restart MySQL:

service mysql restart

Was this answer helpful?

Related Articles

How to use SSH SSH is a tool used to connect to your server. This is how 95% of your system is setup.To... Setting the system date and clock To set the system clock, use the date command.For Redhat Systems, use the following format: date... Linux Command Line Cheat Sheet Moving Around the FilesystemCommands for moving around the filesystem include the following.... What are some basic commands that I need to know to use Linux? If you are new to shell (SSH), below are some commands to get you started. A full list of shell... Basic Commands for Services IPTABLES To check firewall rule set using iptables:iptables -L To Flush/Clear the firewall...

« Back