#ibdata

[azrad]

How to fix issue with DB Storage Engine failure

I have done numerous LAMP stack installation and had no issue with MySQL until recently. Upon checking with the mysqld.log file, it seems my storage engine db init function returned error.

I'm not sure what would caused the issue here, but it seems my findings suggested that the mysql/data files that has something to do with the issue. Reading the log file points that the ib_logfile0 has different size.

So, since the mysqld is already at stopped, I just delete the following files:

ib_logfile0

ib_logfile1

ibdata1

Using the following command to remote the files:

sudo rm /var/lib/mysql/data/ib*

Hope others find the article useful.