Title: Database tables missing
Last modified: July 19, 2017

---

# Database tables missing

 *  [jgold723](https://wordpress.org/support/users/jgold723/)
 * (@jgold723)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/database-tables-missing-3/)
 * 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)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [8 years, 10 months ago](https://wordpress.org/support/topic/database-tables-missing-3/#post-9334279)
 * use phpmyadmin to check and repair (if necessary) those tables.
 *  Thread Starter [jgold723](https://wordpress.org/support/users/jgold723/)
 * (@jgold723)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/database-tables-missing-3/#post-9334334)
 * Thanks — tried that already — no luck. I’m wondering if it’s possible to restore
   default versions of those tables?
 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [8 years, 10 months ago](https://wordpress.org/support/topic/database-tables-missing-3/#post-9334360)
 * > And no, we do not seem to have a backup!
 * ![](https://i0.wp.com/i.giphy.com/c2YyNySJ1CbFC.gif)
 * 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](https://wordpress.org/support/users/jgold723/)
 * (@jgold723)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/database-tables-missing-3/#post-9336998)
 * 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.

## Tags

 * [wp_termmeta](https://wordpress.org/support/topic-tag/wp_termmeta/)
 * [wp_usermeta](https://wordpress.org/support/topic-tag/wp_usermeta/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [jgold723](https://wordpress.org/support/users/jgold723/)
 * Last activity: [8 years, 10 months ago](https://wordpress.org/support/topic/database-tables-missing-3/#post-9336998)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics