Title: Ran into problems while cleaning my database
Last modified: March 30, 2025

---

# Ran into problems while cleaning my database

 *  Resolved [Toyzi](https://wordpress.org/support/users/toyzi/)
 * (@toyzi)
 * [1 year, 2 months ago](https://wordpress.org/support/topic/run-into-problems-while-cleaning-my-database/)
 * On request of my host, I cleaned my database and started for this in the PHPMyAdmin,
   but I have also to clean all unnecessary tables. To be certain that I would delete
   the right tables that had left over after deleting unnecessary plugins I installed“
   Advanced Database Cleaner” recommended by Microsoft copilot and at a certain 
   moment, I ran into the problem I’m here for. More exactly I was deleting tables
   of the pro versions of plugins because I have no pro versions.
 * When you follow the link to it you see at the end it is about next tables that
   don’t exist:
 * “wp9u_posts: Table ‘nexxlitg_nxxtr.wp9u_posts’ doesn’t exist
   wp9u_options: Table‘
   nexxlitg_nxxtr.wp9u_options’ doesn’t existwp9u_terms: Table ‘nexxlitg_nxxtr.wp9u_terms’
   doesn’t existwp9u_term_taxonomy: Table ‘nexxlitg_nxxtr.wp9u_term_taxonomy’ doesn’t
   existwp9u_term_relationships: Table ‘nexxlitg_nxxtr.wp9u_term_relationships’ 
   doesn’t existwp9u_termmeta: Table ‘nexxlitg_nxxtr.wp9u_termmeta’ doesn’t existwp9u_commentmeta:
   Table ‘nexxlitg_nxxtr.wp9u_commentmeta’ doesn’t exist”
 * I don’t know if there has ever been something of these tables that are not there‘
   anymore’, also mentioned on the page or one of the earlier versions. It is the
   first table (when you go to the end of the database) and it contains a.o. an 
   enumeration of all the blogs. Thus is this the network table? The main domain
   page shows an error “Error establishing a database connection”. Normally This
   is quite easy to solve with optimizing the database, but not this time, I always
   return to the same page of the link.
 * I don’t know if I have to use my backup. Can somebody affirm or contradict this?
   Otherwise, I don’t see how to get out of this. I also had to put “define(‘WP_ALLOW_REPAIR’,
   true);” in wp-config.php and it’s always there.
    -  This topic was modified 1 year, 2 months ago by [Toyzi](https://wordpress.org/support/users/toyzi/).
      Reason: Mention last sentence
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Frun-into-problems-while-cleaning-my-database%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Plugin Author [Younes JFR.](https://wordpress.org/support/users/symptote/)
 * (@symptote)
 * [1 year, 2 months ago](https://wordpress.org/support/topic/run-into-problems-while-cleaning-my-database/#post-18394667)
 * Hello [@toyzi](https://wordpress.org/support/users/toyzi/),
 * It sounds like you deleted tables that were actually part of your main WordPress
   site, not just from leftover plugins. Specifically, the tables like wp9u_posts,
   wp9u_options, etc., are core WordPress tables, and if these are missing, your
   site cannot function and you’ll get the “Error establishing a database connection”
   message.
 * Even though they have the prefix wp9u_, that prefix is set in your wp-config.
   php file and it doesn’t mean those tables are from a plugin, it means they’re
   part of your WordPress installation.
 * If you have a full database backup from before the cleanup, please restore it.
   This is the safest and fastest way to recover your site. After restoring your
   site, you can reinstall the Advanced Database Cleaner, but this time be very 
   cautious when deleting tables. You can mark them as “orphaned” and investigate
   their origin before deleting.
 * Kind regards,
   Younes

Viewing 1 replies (of 1 total)

The topic ‘Ran into problems while cleaning my database’ is closed to new replies.

 * ![](https://ps.w.org/advanced-database-cleaner/assets/icon-256x256.png?rev=3405580)
 * [Advanced Database Cleaner – Optimize & Clean Database to Speed Up Site Performance](https://wordpress.org/plugins/advanced-database-cleaner/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/advanced-database-cleaner/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/advanced-database-cleaner/)
 * [Active Topics](https://wordpress.org/support/plugin/advanced-database-cleaner/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/advanced-database-cleaner/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/advanced-database-cleaner/reviews/)

## Tags

 * [db-error](https://wordpress.org/support/topic-tag/db-error/)

 * 1 reply
 * 2 participants
 * Last reply from: [Younes JFR.](https://wordpress.org/support/users/symptote/)
 * Last activity: [1 year, 2 months ago](https://wordpress.org/support/topic/run-into-problems-while-cleaning-my-database/#post-18394667)
 * Status: resolved