How to Fix MySQL Database (MyISAM / InnoDB)

How to Fix MySQL Database (MyISAM / InnoDB)

So… your shiny MySQL database is no longer running and you want to fix it?

You’ve come to the right place!

I’ve assembled a list of 7 ways to fix your MySQL database when a simple restart doesn’t do the trick, or when you have corrupt tables.

Simple MySQL restart:

/usr/local/mysql/bin/mysqladmin -uUSERNAME -pPASSWORD shutdown
/usr/local/mysql/bin/mysqld_safe …Read More