Title: wp_options doesn’t exist Last modified: January 26, 2022 --- # wp_options doesn’t exist * [wtpa](https://wordpress.org/support/users/wtpa/) * (@wtpa) * [4 years, 4 months ago](https://wordpress.org/support/topic/wp_options-doesnt-exist-2/) * Website is getting the error when visiting it “Error establishing a database connection” * Tried to repair database and get the following error “wp_options: Table ‘i6682749_wp1. wp_options’ doesn’t exist” * Tried to recreate the table in my database and get the following error “Tablespace for table ‘`i6682749_wp1`.`wp_options`‘ exists. Please DISCARD the tablespace before IMPORT.” * Need help getting this resolved. * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwp_options-doesnt-exist-2%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 10 replies - 1 through 10 (of 10 total) * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [4 years, 4 months ago](https://wordpress.org/support/topic/wp_options-doesnt-exist-2/#post-15294145) * Try repairing your DB using phpmyadmin: [https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin](https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin) * Thread Starter [wtpa](https://wordpress.org/support/users/wtpa/) * (@wtpa) * [4 years, 4 months ago](https://wordpress.org/support/topic/wp_options-doesnt-exist-2/#post-15294173) * I tried to do a repair from phpmyadmin and it runs fine, but that’s because the wp_options table is completely missing from the database. I don’t know how this happened it just randomly did. One minute the website worked, the next minute it didn’t. * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [4 years, 4 months ago](https://wordpress.org/support/topic/wp_options-doesnt-exist-2/#post-15294686) * Do you or your host have a backup? * Thread Starter [wtpa](https://wordpress.org/support/users/wtpa/) * (@wtpa) * [4 years, 4 months ago](https://wordpress.org/support/topic/wp_options-doesnt-exist-2/#post-15294713) * I have a backup of the database and I don’t know if it doesn’t restore properly or what, but it doesn’t fix it. The backup is from 4 days ago when we KNOW it was working. GoDaddy is the host and they are pathetic and have been fighting with them for 4 hours as they say they can’t do anything. * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [4 years, 4 months ago](https://wordpress.org/support/topic/wp_options-doesnt-exist-2/#post-15294920) * In that backup, there will be a file probably with the extension .sql. In any case, you can restore the whole database or extract just the wp_options part and restore that via PHPMYADMIN. * Thread Starter [wtpa](https://wordpress.org/support/users/wtpa/) * (@wtpa) * [4 years, 4 months ago](https://wordpress.org/support/topic/wp_options-doesnt-exist-2/#post-15294959) * I can’t restore it cause of the Tablespace needing to be discarded. It’s frustrating as all can be. * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [4 years, 4 months ago](https://wordpress.org/support/topic/wp_options-doesnt-exist-2/#post-15295026) * That’s fixable (see [https://stackoverflow.com/questions/15694168/error-tablespace-for-table-xxx-exists-please-discard-the-tablespace-before-imp](https://stackoverflow.com/questions/15694168/error-tablespace-for-table-xxx-exists-please-discard-the-tablespace-before-imp)) BUT should probably be done by your hosting support. * Thread Starter [wtpa](https://wordpress.org/support/users/wtpa/) * (@wtpa) * [4 years, 4 months ago](https://wordpress.org/support/topic/wp_options-doesnt-exist-2/#post-15295066) * They WILL NOT do this. They say they don’t have access and that I need to pay $60 for WordPress Premium Support through them and they might be able to. * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [4 years, 4 months ago](https://wordpress.org/support/topic/wp_options-doesnt-exist-2/#post-15295077) * Well, you could try this, as you’re pretty hosed right now. * In PHPMYADMIN, - export the entire database as another backup. - DROP the database - Restore the old database backup * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [4 years, 2 months ago](https://wordpress.org/support/topic/wp_options-doesnt-exist-2/#post-15537834) * Moderator note: * [@silvanet](https://wordpress.org/support/users/silvanet/) , if you need support then per the forum guidelines please start your own topic. * A lot more people will see your post, and that way you stand a good chance of getting the assistance you want. Despite any similarity in symptoms, your issue is likely to be completely different because of possible differences in physical servers, accounts, hosts, plugins, theme, configurations, etc. Thus one problem, on one setup is not indicative of the functionality and reliability of an application as a whole. * [https://wordpress.org/support/forum-user-guide/faq/#i-have-the-same-problem-can-i-just-reply-to-someone-elses-post-with-me-too](https://wordpress.org/support/forum-user-guide/faq/#i-have-the-same-problem-can-i-just-reply-to-someone-elses-post-with-me-too) * [https://wordpress.org/support/guidelines/#post-in-the-best-place](https://wordpress.org/support/guidelines/#post-in-the-best-place) * You can do so here: * [https://wordpress.org/support/forum/how-to-and-troubleshooting/?view=all#new-post](https://wordpress.org/support/forum/how-to-and-troubleshooting/?view=all#new-post) * I’ll be archiving your post and mine to not spam the original poster and detract from their question. * Thanks. Viewing 10 replies - 1 through 10 (of 10 total) The topic ‘wp_options doesn’t exist’ is closed to new replies. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 10 replies * 3 participants * Last reply from: [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * Last activity: [4 years, 2 months ago](https://wordpress.org/support/topic/wp_options-doesnt-exist-2/#post-15537834) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics