Title: Table Missing Issue
Last modified: August 1, 2023

---

# Table Missing Issue

 *  Resolved [proptrading](https://wordpress.org/support/users/proptrading/)
 * (@proptrading)
 * [2 years, 10 months ago](https://wordpress.org/support/topic/table-missing-issue/)
 * I was optimizing my site using **Advanced Database Clean [plugin](https://wordpress.org/plugins/advanced-database-cleaner/)**.
   I mistakenly deleted some tables, only for me to see that my site has been broken
   as it shows the following errors below:
 * “Error establishing a database connection”.
 * After adding the following codes “define(‘WP_ALLOW_REPAIR’, true);” to myPhpAdmin
   as suggested by WordPress for repair, I still got the following errors:
 * The `wp**_options` table is not okay. It is reporting the following error: `Table'
   ____wp***.wp**_options' doesn't exist`. WordPress will attempt to repair this
   table…
       Failed to repair the `wp**_options` table. Error: `Table '___wp***.
   wp**_options' doesn't exist`
 * The `wp**_postmeta` table is not okay. It is reporting the following error: `
   Table '____wp***.wp**_postmeta' doesn't exist`. WordPress will attempt to repair
   this table…
       Failed to repair the `wp**_postmeta` table. Error: `Table '____wp***.
   wp**_postmeta' doesn't exist`
 *  How can I fix this?
 * Note, I have a backup but it is a week back.
    -  This topic was modified 2 years, 10 months ago by [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/).
      Reason: removed redundant url
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ftable-missing-issue%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [2 years, 10 months ago](https://wordpress.org/support/topic/table-missing-issue/#post-16939155)
 * If you deleted tables, then you can’t repair them…. you can’t repair what’s not
   there. You’ll need to restore your database from a week back.
 * Next time ( 🙂 ) make a backup before cleaning your database.
 *  Thread Starter [proptrading](https://wordpress.org/support/users/proptrading/)
 * (@proptrading)
 * [2 years, 10 months ago](https://wordpress.org/support/topic/table-missing-issue/#post-16940760)
 * That is right, thank you for the advice.
 * I have been able to fix it by restoring a backup.

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

The topic ‘Table Missing Issue’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [proptrading](https://wordpress.org/support/users/proptrading/)
 * Last activity: [2 years, 10 months ago](https://wordpress.org/support/topic/table-missing-issue/#post-16940760)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics