Aug 052019
 

Remove AIOWPS From WP Database Tables And Options shows you how to delete aiowps tables and options in your database and more.

Last Updated: February 10, 2020

Latest News: Updated the documentation.

There are many plugins in WordPress repository that help you clean your database, but today we are going to concentrate on Advanced Database Cleaner plugin. This tutorial shows you how to search your sites database for aiowps “All In One WP Security & Firewall plugin” tables and other entries using Advanced Database Cleaner plugin. What this means is that you don’t have to log into your server and use phpMyAdmin or something similar to clean your database. This tutorial helps you clean your database and totally remove any entries from aiowps plugin without having to leave your site.

WP Database Cleaner Tutorials:

Remove AIOWPS From WP Database Tables And Options

Important: Before you begin, make sure you create a database backup of your site. Just in case something goes wrong.

Step 1 ) Go to WP DB Cleaner as illustrated in the image below to start searching for tables, options and other entries you want to remove from your database that is associated with aiowps plugin.

wp-database-cleaner-plugin-admin-panel-new

Step 2 ) Go to WP DB Cleaner -> Tables as illustrated in the image below to delete obsolete tables associated with aiowps plugin. Remember to read the note in yellow, it is important that you don’t delete any table that is not associated with aiowps plugin.

wp-database-cleaner-plugin-tables-tab-options-new

Step 2-a ) The following image shows you six tables found in Tables tab. These tables are safe to delete. Once you have selected the tables, click on Bulk Actions button and click on Delete from the drop down menu.

Tables Safe To Delete

  • aiowps_events
  • aiowps_failed_logins
  • aiowps_global_meta
  • aiowps_login_activity
  • aiowps_login_lockdown
  • aiowps_permanent_block

wp-database-cleaner-plugin-tables-name

Step 3 ) Go to WP DB Cleaner -> Options as illustrated in the image below to delete obsolete options for aiowps plugin. Remember to read the note in yellow, it is important that you don’t delete any option that is not associated with aiowps plugin.

wp-database-cleaner-optomize-tab-options-new

Step 3-a ) The following image shows you two entries found under Options tab. The other entries are also added to the database depending on the features you enable in the plugin. If you find other entries in options, please let me know and I will add them to the list below.

These options are safe to delete. Once you have selected these options, click on Bulk Actions button and click on Delete from the drop down menu.

Options Safe To Delete

  • aiowpsec_db_version
  • aio_wp_security_configs

Other Entries Found In Options Safe To Delete

  • aiowps_temp_configs
  • _site_transient_update_plugins
  • _transient_plugin_slugs

wp-database-cleaner-plugin-options-name.

The above steps should help you remove all aiowps entries from your database options table without moving from your site.

If you have any questions please let me know. I will be updating this post from time to time. So keep coming back for the latest.

Enjoy.

I have been working in IT since 1999 and I enjoy the challenges it brings me. I love developing websites with WordPress. I spend a lot of time helping out in wordpress.org forums. I have been writing tutorials since 2011. Now I am learning how to manage my own VPS "Virtual Private Server.

  4 Responses to “Remove AIOWPS From WP Database Tables And Options”

  1. Hi,

    Justo to say I’ve followed your tutorial to remove the aiowps entries.
    But it seems that they weren’t definetely deleted, as when I get the plugin reinstalled all the information came back.

    In the Step 3 of this tutorial, the two “Options Safe to Delete” are the same. You mean “aiowpsec_db_version” and “aio_wp_security_configs”, right?

    Thanks anyway
    Gracinda

    • Hi Gracinda, thank you for pointing that out. I have updated Step 3 ) in the documentation above.

      If you deleted all tables and other entries mentioned in this documentation and you still have an issue, then there might be other settings in the plugin that creates an entry in your database. Can you please confirm this and report back.

      Thank you

      • Hi,

        Thank you for your response.

        I’ve tried again and I found out that besides the 2 entries in the Options, there was one more “aiowps_temp_configs.
        With this last one deleted I was able to reinstall AIOWPS.

        Thank you again
        Gracinda

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)