After converting one of our databases to MyISAM from InnoDB everything seems to be fine except for the below error message spamming the log for each table in that database. We had a file system issue a little while back and I've recovered from it using backups. I'm not sure if it's relevant but it might be. I've also noticed that I can no longer complete a 'mysqlcheck --all-databases -r' or 'mysqlcheck --all-databases -o' anymore and receive the error:
When I view the error log to determine what caused the repair/optimize to fail all I see is the original error:
spammed some more along with the following:
followed by a large dump.
I've been trying to research the best way to resolve this but I'm not very knowledgeable with this yet and everything is working so I don't want to break anything else trying to fix it. Any ideas would be much appreciated as it would be nice to be able to complete a repair and optimize again.
Code:
mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'REPAIR TABLE ... '
Code:
140310 14:14:50 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
140310 14:14:50 InnoDB: Error: trying to open a table, but could not
InnoDB: open the tablespace file './database/table.ibd'!
InnoDB: Have you moved InnoDB .ibd files around without using the
InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE?
InnoDB: It is also possible that this is a temporary table #sql...,
InnoDB: and MySQL removed the .ibd file for this.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
Code:
InnoDB: Page directory corruption: infimum not pointed to
140310 14:19:34 InnoDB: Page dump in ascii and hex (16384 bytes):
I've been trying to research the best way to resolve this but I'm not very knowledgeable with this yet and everything is working so I don't want to break anything else trying to fix it. Any ideas would be much appreciated as it would be nice to be able to complete a repair and optimize again.