Title: Database Prefix Question
Last modified: May 13, 2024

---

# Database Prefix Question

 *  Resolved [Firelight](https://wordpress.org/support/users/mdc2957/)
 * (@mdc2957)
 * [2 years ago](https://wordpress.org/support/topic/database-prefix-question/)
 * Hope someone can help me out here.. I was just looking through my database and
   notice that I have what appear to be duplicate tables with different prefixes.
   I _think_ what happened was that I changed the prefix using this plugin, then
   later deleted the plugin which I think changed the prefix back to wp_ Is that
   what happens when you delete the plugin? Does the prefix go back to wp_? In any
   event, I just looked in my wp config file and the current prefix is indeed wp_
   When the prefix gets changed, do the system duplicate all the existing tables
   with the new prefix? If that’s the case, can I drop all the other different prefix
   tables?

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

 *  Plugin Support [hjogiupdraftplus](https://wordpress.org/support/users/hjogiupdraftplus/)
 * (@hjogiupdraftplus)
 * [2 years ago](https://wordpress.org/support/topic/database-prefix-question/#post-17752749)
 * Hi [@mdc2957](https://wordpress.org/support/users/mdc2957/)
 * If you deactivate or delete the AIOS plugin it does not change prefix back to
   wp_.
 * It will keep the changed table prefix in database and in wp-config.php.
 * Do you have any staging plugin installed it might be the reason or the website
   copied from another place it can also be the reason.
 * Yes, please take the backup of the whole DB and keep tables with `$table_prefix`
   as per wp-config.php and drop all other tables.
 * Regards
 *  Thread Starter [Firelight](https://wordpress.org/support/users/mdc2957/)
 * (@mdc2957)
 * [2 years ago](https://wordpress.org/support/topic/database-prefix-question/#post-17753959)
 * Ah yes, I did have staging set up via a backup plugin I was using (but no longer
   am as I had troubles with it), so that must be the reason. I Imagine that duplicate
   tables should have been deleted by that plugin when I removed the staging site,
   but as noted it was giving me issues. Thanks for the reminder, much appreciated.
 *  Plugin Support [hjogiupdraftplus](https://wordpress.org/support/users/hjogiupdraftplus/)
 * (@hjogiupdraftplus)
 * [2 years ago](https://wordpress.org/support/topic/database-prefix-question/#post-17755959)
 * Hi [@mdc2957](https://wordpress.org/support/users/mdc2957/)
 * Ok,
 * You’re welcome.
 * Would you mind writing a quick five-star review on wordpress.org?
 * [https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/reviews/#new-post](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/reviews/#new-post)
 * Reviews also help others to make confident decisions about our plugin.
 *  Thread Starter [Firelight](https://wordpress.org/support/users/mdc2957/)
 * (@mdc2957)
 * [2 years ago](https://wordpress.org/support/topic/database-prefix-question/#post-17758599)
 * I wouldn’t be able to rate the plugin as I did not end up using it, so nothing
   negative, nor positive to say about the plugin itself. But I appreciate your 
   prompt reply here on the support forum.
 *  Plugin Support [hjogiupdraftplus](https://wordpress.org/support/users/hjogiupdraftplus/)
 * (@hjogiupdraftplus)
 * [2 years ago](https://wordpress.org/support/topic/database-prefix-question/#post-17758993)
 * Ok, No problem.

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

The topic ‘Database Prefix Question’ is closed to new replies.

 * ![](https://ps.w.org/all-in-one-wp-security-and-firewall/assets/icon-256x256.
   png?rev=2798307)
 * [All-In-One Security (AIOS) – Security and Firewall](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/)
 * [Active Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [duplicate](https://wordpress.org/support/topic-tag/duplicate/)
 * [prefix](https://wordpress.org/support/topic-tag/prefix/)
 * [tables](https://wordpress.org/support/topic-tag/tables/)

 * 5 replies
 * 2 participants
 * Last reply from: [hjogiupdraftplus](https://wordpress.org/support/users/hjogiupdraftplus/)
 * Last activity: [2 years ago](https://wordpress.org/support/topic/database-prefix-question/#post-17758993)
 * Status: resolved