WordPress.org

1. Loggy
   Member
   Posted 5 months ago #

   I have a question about the various Database Reset plugins.

   Which (if any) of these will clean out the tables, removing unused tables and all the junk from the options table while leaving the data for currently installed (but maybe deactivated) plugins and themes alone?

   In other words, cleaning the database would have list all entries from all plugins and themes currently installed plus of course the core code and not touch them but remove the unwanted contents.

   This is quite a big task which would have to mimic all installed plugin/theme activity although presumably as long as the plugin/theme maintains the correct prefix for tables and entries within tables, it may not be so big a problem.

   I am not secure that any of the present database cleaning plugins will do this - they mainly refer to returning the intallation to a 'virgin' state which could imply they will remove data from activated and deactivated plugins and themes.

   TIA

2. Jonathan Dingman
   Member
   Posted 5 months ago #

   Here's a post from 3 years ago that's still relevant today:

   http://wordpress.org/support/topic/clean-out-the-database

3. Loggy
   Member
   Posted 5 months ago #

   Thanks Jonathan. It seems there is no such facility.

   As I suspected it would be quite difficult given that not all plugins and themes that people may use actually obey the rules and checking on created tables would really mean parsing all the php in each setup. And the table contents - particularly the _options table - would be even more difficult :-)

Reply

You must log in to post.