Magento just lost the ability to open the primary database.

I am getting this error when I try to access the database from both Webmin and Navicat. I expect PHPMYADMIN is the same.

SQL show index from `admin_assert` failed : Unknown table engine 'InnoDB'

Magento is returning:

There has been an error processing your request

Exception printing is disabled by default for security reasons.

Any thoughts on how to fix this without a full Restore?

thanks in advance for any help.

Replies (2)

Have you tried removing the logs?

Reply 1 2012-05-02

IIRC INNODB causes problems if/when the log files get corrupted. I recall some time ago removing the logsand restarting MySQL solved a similar problem. Could be wrong though...

Went to clean the logs myself but could not find them..

Reply 2 2012-05-02

There is an old, somewhat difficult thread, which Alon is helping a fellow newb that refers to essentially the same the problem. I tried a few of the "solutions" but mainly could not find the log files to delete.

I did issue a command and got an error. Perhaps that was the action though that solved this.

Long story is that it came back up. Started and stopped MySQL a few times. Verified that InnoDB is a valid Engine.... yada yada.

Running again. Scary situation but behind for now.

Thanks for the guidance.