L. Arnold's picture

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.

Jeremy Davis's picture

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...

L. Arnold's picture

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.

Add new comment