Title: Missing MySQL Database Tables
Last modified: January 12, 2017

---

# Missing MySQL Database Tables

 *  [webinate](https://wordpress.org/support/users/webinate/)
 * (@webinate)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/missing-mysql-database-tables/)
 * Hi Everyone,
 * I need advice please. I am running a new WP website, and checked it this morning,
   and everything was fine. I logged in, created some new pages, but haven’t added
   content to them.
 * I went to log back in tonight, and failed to produce the login page, and instead
   wanted me to initiate a new WP install.
 * There was obviously an issue, so I attempted to get WP to repair tge MySQL database,
   using FTP to add the following to my “wp-config.php” file :
    define(‘WP_ALLOW_REPAIR’,
   true);
 * I then attempted to log into WP with this URL :
    “[http://www.yoursite.com/wp-admin/maint/repair.php&#8221](http://www.yoursite.com/wp-admin/maint/repair.php&#8221);
   but with my own domain name. WP then asked me if I wanted to “repair” or “repair
   and optimize” the database. I chose “repair”, which failed with a report telling
   me to post the following here :
 * wp_users: Table ‘db1129360_lproj.wp_users’ doesn’t exist
    wp_usermeta: Table ‘
   db1129360_lproj.wp_usermeta’ doesn’t exist wp_posts: Table ‘db1129360_lproj.wp_posts’
   doesn’t exist wp_comments: Table ‘db1129360_lproj.wp_comments’ doesn’t exist 
   wp_links: Table ‘db1129360_lproj.wp_links’ doesn’t exist wp_options: Table ‘db1129360_lproj.
   wp_options’ doesn’t exist wp_postmeta: Table ‘db1129360_lproj.wp_postmeta’ doesn’t
   exist wp_terms: Table ‘db1129360_lproj.wp_terms’ doesn’t exist wp_term_taxonomy:
   Table ‘db1129360_lproj.wp_term_taxonomy’ doesn’t exist wp_term_relationships:
   Table ‘db1129360_lproj.wp_term_relationships’ doesn’t exist wp_termmeta: Table‘
   db1129360_lproj.wp_termmeta’ doesn’t exist wp_commentmeta: Table ‘db1129360_lproj.
   wp_commentmeta’ doesn’t exist
 * I have also tried disabling all plugins via FTP, but this hasn’t helped.
 * I have also double-checked (again with FTP) that the database credentials in “.
   htaccess” are correct.
 * This is a major blow for me, and I don’t know what to do next. Can anyone offer
   any assistance please? My website is at [http://www.lprojects.com.au/](http://www.lprojects.com.au/)
 * My thanks for taking the time to read this post.
 * Kind regards,
    David

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

 *  Moderator [t-p](https://wordpress.org/support/users/t-p/)
 * (@t-p)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/missing-mysql-database-tables/#post-7223468)
 * First, check with your hosting provider if the db server having problems.
 *  Thread Starter [webinate](https://wordpress.org/support/users/webinate/)
 * (@webinate)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/missing-mysql-database-tables/#post-7223488)
 * Hello Tara,
 * Thanks for getting back to me so quickly – I’m amazed and impressed!
 * Before I logged this issue with you guys at wp.org, I emailed a support request
   to my hosting provider. It will be some hours before I get a response from them,
   but I’ll wait for that before I get back to wp.org.
 * Thank you again.
 * David
 *  [Favored](https://wordpress.org/support/users/favored/)
 * (@favored)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/missing-mysql-database-tables/#post-8645920)
 * i got the same same problem with my dbs. my host tried and failed to restore 
   the db connections. any please will be appreciated. sir did you get the solution
   to this problem?
 *  Moderator [t-p](https://wordpress.org/support/users/t-p/)
 * (@t-p)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/missing-mysql-database-tables/#post-8647289)
 * [@favored](https://wordpress.org/support/users/favored/),
    If you noticed, this
   is a rather old (9-month!) thread 🙂
 * If the troubleshooting already posted made no difference for you, then, as per
   the [Forum Welcome](http://codex.wordpress.org/Forum_Welcome#Where_To_Post), 
   please [post your own topic](http://wordpress.org/support/forum/how-to-and-troubleshooting#postform).
   That way you stand a good chance of getting the assistance you want.
 * I’m closing this thread.

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

The topic ‘Missing MySQL Database Tables’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [table error](https://wordpress.org/support/topic-tag/table-error/)

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

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics