Broken DataBase

franckmora
(@franckmora)

4 years, 4 months ago
Hi,

After some rollbacks, our WordPress DataBase is broken.

It is impossible for us to connect to the WP admin panel.

We launched the Database back up tool from WordPress, it didn’t solve the issue.

I would need help fixing this, please 🙂

Here are the errors displayed by wordpress after initiating the WordPress database backup tool.
```
quY9u8_comments: Table 'wp_9wn2g.quY9u8_comments' doesn't exist
quY9u8_links: Table 'wp_9wn2g.quY9u8_links' doesn't exist
quY9u8_options: Table 'wp_9wn2g.quY9u8_options' doesn't exist
quY9u8_postmeta: Table 'wp_9wn2g.quY9u8_postmeta' doesn't exist
quY9u8_commentmeta: Table 'wp_9wn2g.quY9u8_commentmeta' doesn't exist
```
Thank you in advance for your help !

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

corrinarusso
(@corrinarusso)

4 years, 4 months ago

It is not likely your “WordPress database is broken”.
It is far more likely there is a setting or file not functioning properly.

To troubleshoot effectively, view your database by logging into your host, and using phyMyAdmin – check to see if these tables actually exist or not:
wp_9wn2g.quY9u8_comments

Here is one example on how to launch phpMyAdmin:
https://www.hostgator.com/help/article/how-to-access-phpmyadmin-from-cpanel

Next step would be to verify the table prefix in your wp-config file, here is an example on how to check:
https://help.one.com/hc/en-us/articles/360002107438-Change-the-table-prefix-for-WordPress-

Post back once you have these two answers.
Moderator Jan Dembowski
(@jdembowski)

Forum Moderator and Brute Squad

4 years, 4 months ago
@franckmora Please, please, PLEASE never post sensitive data in these extremely public, not private in anyway, copied to the Internet almost immediately forums.

You posted your database details such as DB user ID and DB password. We don’t need that or want that.

I have archived your reply.
- This reply was modified 4 years, 4 months ago by Jan Dembowski.
Thread Starter franckmora
(@franckmora)

4 years, 4 months ago

@jdembowski thank you and sorry for my mistake.

If think the information bellow doesn’t contain any sensitive data and might help understanding the issue, or bringing more details that would help its resolution.

We were speaking about the prefix configuration, and here it is :

`$table_prefix = ‘quY9u8_’

Thank you

corrinarusso
(@corrinarusso)

4 years, 4 months ago

Ddi you check this part and see if those tables exist or not?

Here is one example on how to launch phpMyAdmin:
https://www.hostgator.com/help/article/how-to-access-phpmyadmin-from-cpanel

Thread Starter franckmora
(@franckmora)

4 years, 4 months ago

Those tables do not exist on PhpMyAdmin.

corrinarusso
(@corrinarusso)

4 years, 4 months ago

Perfect. Now you can say with confidence what is wrong.

Not many options really, you can load a stable backup of your database using the Import functions from phpMyAdmin, you could re-install WordPress core.

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

The topic ‘Broken DataBase’ is closed to new replies.

Broken DataBase

Tags

Topics

Topics with no replies

Non-support topics

Resolved topics

Unresolved topics

All topics