Yesterday, out of the blue, the MySQL working as a backend for my private postfix server stopped working. No log entries, nothing, it just won't start. I reinstalled it and it worked until I copied the origanl databases to /var/lib/mysql. To be more exact, it fails as soon as I copy ibdata1. Since it wasn't much data and it can be reconstructed, I don't have a dump. Is there any way to recover the data from the database binaries?
Best regards
Answer found here: https://stackoverflow.com/questions/484750/restoring-mysql-database-from-physical-files
You should be able to restore by copying them in your database folder.
You should do it while the server is not running.
In case anyone encounters the same problem, I already found the solution. Sorry to have bothered you: http://chepri.com/mysql-innodb-corruption-and-recovery/
May a mod can decide if this question is worth keeping or should be deleted.
