How to Recover InnoDB MySQL Table Data from ibdata and .frm Files
This tutorial explains how to restore MySQL tables when all or some of the tables are lost, or when MySQL fails to load table data.
One of the reason for this to happen is when the table data is corrupted.
In …Read More
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