wpsnoop: Origins of the WordPress database table "wp_defender_lockout"
WordPress is comprised of many database tables and many plugins and themes operate without needing to create new tables. When asked where did the table wp_defender_lockout come from?
This page provides some information on the wp_defender_lockout table and a list of plugins and themes where it may have originally come from.
Can the wp_defender_lockout table be deleted safely?Maybe. It depends on your situation: If you are sure that you no longer use the plugin or theme that created the wp_defender_lockout table you can certainly delete it with phpMyAdmin BUT we would suggest renaming the table to something else like old-wp_defender_lockout and make sure your WordPress installation still works :)
Assuming everything seems ok after renaming the table you can safely DROP old-wp_defender_lockout and carry on.
Remember that backups are your friend so make them often and if necessary consider hiring a professional to assist you.
MySQL orphan or zombie database table named "wp_defender_lockout" infoA database table called "wp_defender_lockout" seems to persist and is not cleanly removed by the following plugin/theme:
|Defender||Plugin||Get help with Defender cleanup or errors|
Orphaned or Zombie tables can take up space in MySQL, add to your server load and could present conflicts with other plugins or themes. It is recommended that you invest a bit of effort removing the "zombie" database tables if you have no plans to use that plugin or theme in future. Remember to make backups.
Normal WordPress Database Tables
The following are commmonly WordPress database tables found in all standard installations
Many of these tables are related to each other, for a very complete and informative post explaining in great detail the inner workings of the WordPress table structure check out the wordpress codex database description