Forums

Clean-up _OPTIONS table (6 posts)

  1. rednus
    Member
    Posted 3 years ago #

    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...

  2. MichaelH
    Volunteer
    Posted 3 years ago #

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

  3. rednus
    Member
    Posted 3 years ago #

    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)

  4. elfin
    Moderator
    Posted 3 years ago #

    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.

  5. MichaelH
    Volunteer
    Posted 3 years ago #

    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...

  6. Mittineague
    Member
    Posted 3 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic