Database Repair didn’t work & site is down!

  • tagdesigner

    (@tagdesigner)


    8 years ago

    I received the following message after trying to repair the database on a client’s website. Now what can I do? I need to get this site up & running! Help!!!

    wp_users: Unknown storage engine ‘InnoDB’
    wp_usermeta: Unknown storage engine ‘InnoDB’
    wp_posts: Unknown storage engine ‘InnoDB’
    wp_comments: Unknown storage engine ‘InnoDB’
    wp_links: Unknown storage engine ‘InnoDB’
    wp_options: Unknown storage engine ‘InnoDB’
    wp_postmeta: Unknown storage engine ‘InnoDB’
    wp_terms: Unknown storage engine ‘InnoDB’
    wp_term_taxonomy: Unknown storage engine ‘InnoDB’
    wp_term_relationships: Unknown storage engine ‘InnoDB’
    wp_commentmeta: Unknown storage engine ‘InnoDB’

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Why did you try to repair the DB in the first place? Is this a new install? A moved site? Please provide some background and context.

    The issue is that you’ve specified InnoDB as the storage engine and it looks like it’s not enabled on this MySQL server.

    Luke Cavanagh

    (@lukecavanagh)

    @tagdesigner

    If you look in INFORMATION_SCHEMA table of the site DB, it will show which storage engine is being used.

    https://dev.mysql.com/doc/refman/5.7/en/tables-table.html

    To enable InnoDB in cPanel

    To enable the InnoDB database engine, open up /etc/my.cnf in an editor(such as vim), and comment out the skip-innodb line:

    Change:
    [mysqld]
    skip-innodb

    To:
    [mysqld]
    #skip-innodb

    Then restart the MySQL services

    service restart mysql

    • This reply was modified 8 years ago by Luke Cavanagh. Reason: clarify wording
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database Repair didn’t work & site is down!’ is closed to new replies.