We have had a database crash and are not able to recover the data that is stored in the InnoDB tables. I haven't found a similar problem on the internet and I hope someone can help me out here. This is kinda our last hope 😉
Our website was hosted on a temporary server for a few months. The backup procedure did not work propperly and we had a server crash. The disk was full due to big dump files. As far as I know a cached file was removed that was related to MySQL to free up disk space. I presume this file was not needed in any way and it could be removed.
After this "crash", MySQL would not restart. But after the second attempt it did. All MyIsam tables are working fine, but the InnoDB tables are unreadable. The only thing that I can see is that PhpMyAdmin returns "Table in use" for each of the InnoDB tables.
We must make the decision between restoring an (very) old backup or keep on trying to find a way to recover the data.
Is there anyone who can give me some helpfull tips on recovering the data from the (locked?) InnoDB tables?
Thanks in advance.
