WP Database repare

  • Resolved rgbcom

    (@rgbcom)


    8 months, 2 weeks ago

    Hi to all,

    Am trying to login to my /wp-admin and being redirected to wp-admin/install.php.
    Tried repairing the database thru /wp-admin/maint/repair.php and which resulted in:

    wpuv_users: Unknown storage engine ‘InnoDB’
    wpuv_usermeta: Unknown storage engine ‘InnoDB’
    wpuv_posts: Unknown storage engine ‘InnoDB’
    wpuv_comments: Unknown storage engine ‘InnoDB’
    wpuv_links: Unknown storage engine ‘InnoDB’
    wpuv_options: Unknown storage engine ‘InnoDB’
    wpuv_postmeta: Unknown storage engine ‘InnoDB’
    wpuv_terms: Unknown storage engine ‘InnoDB’
    wpuv_term_taxonomy: Unknown storage engine ‘InnoDB’
    wpuv_term_relationships: Unknown storage engine ‘InnoDB’
    wpuv_termmeta: Unknown storage engine ‘InnoDB’
    wpuv_commentmeta: Unknown storage engine ‘InnoDB’

    This looks like a server problem?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Mridul Goswami

    (@mridulgoswami)

    8 months, 2 weeks ago

    Hey there

    Yes, this is a server-side MySQL/MariaDB problem. WordPress is redirecting to /wp-admin/install.php because it can’t read your tables. InnoDB engine isn’t available (or has crashed). Since all your WP tables are InnoDB, every query fails and WP thinks it’s not installed.

    If you can then access the server through SSH and see what whether the SQL Server is running.
    If you can not access the server through SSH may be you have CPanel, in the CPanel you can check if the database is running or has the service stopped.
    If you dont have CPanel or anyother interface, I recommend that you contact your hosting provider for the right solution.

    Please consider this as well, don’t run WordPress installer or “repair DB” again, it won’t help until InnoDB loads. Also do not delete or remove any existing tables since doing so will result in data loss.

    I hope this helps you in taking the right decision.

    Take care

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    8 months, 2 weeks ago

    As mentioned above, please contact your host to restart the InnoDB database engine.

    Thread Starter rgbcom

    (@rgbcom)

    8 months, 2 weeks ago

    Thanks to both! I needed this confirmation to discuss with my client. Yes the MySQL server is running.

    I successfully created a test_myisam table.

    Regards 😊

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    8 months, 2 weeks ago

    InnoDB needs to be enabled as an engine within MySQL/MariaDB. Contact your host.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘WP Database repare’ is closed to new replies.