Saturday, May 21, 2011

MySql InnoDB tables getting corrupted

One not-so-common issue I faced when my db crashed because of disk-space issue on the server machine.
After cleaning up the space, when I tried to restart the database and recreated the schema, all the tables were getting created of type MYISAM even though the db create script as well as my.cnf enforced the tables to be InnoDB.

Resolution: The issue can get resolved by deleting ib* files from /var/lib/mysql.
cd /var/lib/mysql
rm ib*
/etc/init.d/mysqld restart

No comments:

Post a Comment