Thursday, May 3, 2012

mysql wont start after server crashed

My mysql database crashed after saving a snapshot thru KVM. Restarting mysqld shows errors under /var/log/mysqld.log

..check that your my.cnf matches the ibdata files..


one solution was to move all ib* data and restart mysqld
 mkdir /srv/mysql/old
mv /srv/mysql/ib* /srv/mysql/old
service mysqld restart

No comments: