TurnKey Linux Virtual Appliance Library

INNODB broken in MySQL Magento (any thoughts?)

larnold'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

Have you tried removing the logs?

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

Landis Arnold's picture

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

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.

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)