I have a MySQL server that serves a couple of databases including a Magento e-commerce store.
We have been suffering with corruption in the ibdata1 file for a while, but it has now reached a critical point.
The only database that uses innodb tables is the Magento webstore back-end.
I have an up to date SQL extract of the entire magento database. I thought that I could shut down MySQL, rename the ib* files, restart MySQL and re-create the database from the SQL file - however I am having a major problem restarting MySQL after renaming the ib* files.
I keep getting 'cannot connect to mysql ..... mysql.sock'.
It appears as though the ib* files are all re-created as I would expect, but I can't restart and then connect to the sever...