WordPress.org

Support

Support » How-To and Troubleshooting » Database Repair/Error Table

Database Repair/Error Table

  • Hi all,
    I’m having an issue that I can’t seem to troubleshoot myself.

    I received a database connection error, and am unable to login to my site.

    Below are the database problems that could not be repaired.

    wp_users: Table ‘mysite_wrdp1.wp_users’ doesn’t exist
    wp_usermeta: Table ‘mysite_wrdp1.wp_usermeta’ doesn’t exist
    wp_21_posts: Table ‘mysite_wrdp1.wp_21_posts’ doesn’t exist
    wp_21_comments: Table ‘mysite_wrdp1.wp_21_comments’ doesn’t exist
    wp_21_links: Table ‘mysite_wrdp1.wp_21_links’ doesn’t exist
    wp_21_options: Table ‘mysite_wrdp1.wp_21_options’ doesn’t exist
    wp_21_postmeta: Table ‘mysite_wrdp1.wp_21_postmeta’ doesn’t exist
    wp_21_terms: Table ‘mysite_wrdp1.wp_21_terms’ doesn’t exist
    wp_21_term_taxonomy: Table ‘mysite_wrdp1.wp_21_term_taxonomy’ doesn’t exist
    wp_21_term_relationships: Table ‘mysite_wrdp1.wp_21_term_relationships’ doesn’t exist

    Any help would be much appreciated!

Viewing 5 replies - 1 through 5 (of 5 total)
  • esmi

    @esmi

    Forum Moderator

    Do you have a recent database backup? Do your hosts?

    Yes I have a recent backup, I have not restored it yet because I was unsure if I was just going to end up with the same error or not.

    esmi

    @esmi

    Forum Moderator

    Well, judging by those errors, your database(s) may have been trashed. Have you spoken to your hosts about this? Do you have more than 1 install in the database?

    Yes I have more than 1 install, I’m running a multisite.

    I just tried restoring my site, and I’m still unable to login…

    Is this a WordPress error or something going on with my host(Hostgator/VPS)?

    esmi

    @esmi

    Forum Moderator

    It’s likely to be an issue with your hosts.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Database Repair/Error Table’ is closed to new replies.