wp_options doesn’t exist

wtpa
(@wtpa)

4 years, 4 months ago

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 to see the link]

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

Moderator Steven Stern (sterndata)
(@sterndata)

Volunteer Forum Moderator

4 years, 4 months ago

Try repairing your DB using phpmyadmin: https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin

Thread Starter wtpa
(@wtpa)

4 years, 4 months ago

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)
(@sterndata)

Volunteer Forum Moderator

4 years, 4 months ago

Do you or your host have a backup?

Thread Starter wtpa
(@wtpa)

4 years, 4 months ago

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)
(@sterndata)

Volunteer Forum Moderator

4 years, 4 months ago

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
(@wtpa)

4 years, 4 months ago

I can’t restore it cause of the Tablespace needing to be discarded. It’s frustrating as all can be.

Moderator Steven Stern (sterndata)
(@sterndata)

Volunteer Forum Moderator

4 years, 4 months ago

That’s fixable (see 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
(@wtpa)

4 years, 4 months ago

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)
(@sterndata)

Volunteer Forum Moderator

4 years, 4 months ago
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)
(@sterndata)

Volunteer Forum Moderator

4 years, 1 month ago

Moderator note:

@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://ww.wp.xz.cn/support/forum-user-guide/faq/#i-have-the-same-problem-can-i-just-reply-to-someone-elses-post-with-me-too

https://ww.wp.xz.cn/support/guidelines/#post-in-the-best-place

You can do so here:

https://ww.wp.xz.cn/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.

wp_options doesn’t exist

Tags

Topics

Topics with no replies

Non-support topics

Resolved topics

Unresolved topics

All topics