Clean-up _OPTIONS table

  • All, I have been trying out quite a few plug-ins for my site.. and where provided I have used uninstall feature.. but for those without uninstall I have just deactivated and deleted the plug-in.. however i found out that the table entries created in _OPTIONS still exist.. is there anyway to clean this table…

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

  • Use phpMyAdmin to do that. Backup your database before attempting…

    Thread Starter rednus

    (@rednus)

    Hi MichaelH, I know i can do it from phpmyadmin.. but that is a long and time taking process and there is a possibility of making mistakes.. i was looking for a tool like optimizeDB which can do it for me.. ?? (see i am lazy)

    Anonymous User

    (@anonymized-3085)

    you’d need a plugin that

    1. checks every php file of every active plugin for add_option, or update option
    2. check against a list of every standard wordpress option
    3. compares list to options in the options table
    4. deletes all it can’t find

    not something I’d want to write.

    Then another avenue is to use Manage->Export to export your blog, DROP your WordPress tables, run the wp-admin/install.php process, then do Manage->Import->WordPress.

    Again, please backup your database before attempting…

    No need to write a plugin to do it, I already have –
    Clean Options Plugin

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Clean-up _OPTIONS table’ is closed to new replies.