L. Arnold's picture
L. Arnold - Wed, 2012/05/02 - 06:17

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.

Forum: 
Support
Tags: 
mysql
innodb
Jeremy Davis's picture

Jeremy Davis - Wed, 2012/05/02 - 15:49

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

L. Arnold - Wed, 2012/05/02 - 17:35

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