Database tables missing

  • jgold723

    (@jgold723)


    6 years, 9 months ago

    We’ve been trying to troubleshoot an admin page redirect issue (when trying to login to the the admin side we get redirected to the home page).

    One issue we’ve discovered is that there are damaged or missing tables in the database. See the report below. Is there a way to rebuild/replace these tables?

    And no, we do not seem to have a backup!

    [trichur_wp526.wp_commentmeta] status: OK
    [trichur_wp526.wp_comments] status: OK
    [trichur_wp526.wp_links] status: OK
    [trichur_wp526.wp_options] status: OK
    [trichur_wp526.wp_postmeta] status: OK
    [trichur_wp526.wp_posts] status: OK
    [trichur_wp526.wp_term_relationships] status: OK
    [trichur_wp526.wp_term_taxonomy] status: OK
    [trichur_wp526.wp_termmeta] Error: Table ‘trichur_wp526.wp_termmeta’ doesn’t exist
    [trichur_wp526.wp_termmeta] status: Operation failed
    [trichur_wp526.wp_terms] status: OK
    [trichur_wp526.wp_usermeta] Error: Can’t find file: ‘wp_usermeta’ (errno: 2)
    [trichur_wp526.wp_usermeta] status: Operation failed
    [trichur_wp526.wp_users] status: OK

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

    (@sterndata)

    Volunteer Forum Moderator

    6 years, 9 months ago

    use phpmyadmin to check and repair (if necessary) those tables.

    Thread Starter jgold723

    (@jgold723)

    6 years, 9 months ago

    Thanks — tried that already — no luck. I’m wondering if it’s possible to restore default versions of those tables?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    6 years, 9 months ago

    And no, we do not seem to have a backup!

    You could create a new install of WordPress and then export/import those tables. Your site may have issues related to users and taxonomy items afterwards. Backup your db first!

    Thread Starter jgold723

    (@jgold723)

    6 years, 9 months ago

    Yeah, yeah, yeah, I know. A couple of questions:
    1) Would a missing/broken usermeta table cause admin logins to redirect to the home page?

    2) If I’m doing database work, would it be better to create a new database and then import my posts from the broken db to that? Or better to export the tables from the new db and attempt to import them into the broken db?

    Just to clarify — there are only two tables in the “broken db” that are damaged. The rest check out OK.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database tables missing’ is closed to new replies.