wpsnoop: Origins of the WordPress database table "wp_wpsa_subscribe_author"
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_wpsa_subscribe_author come from?
This page provides some information on the wp_wpsa_subscribe_author table and a list of plugins and themes where it may have originally come from.
Can the wp_wpsa_subscribe_author 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_wpsa_subscribe_author table you can certainly delete it with phpMyAdmin BUT we would suggest renaming the table to something else like old-wp_wpsa_subscribe_author and make sure your WordPress installation still works :)Assuming everything seems ok after renaming the table you can safely DROP old-wp_wpsa_subscribe_author and carry on.
Remember that backups are your friend so make them often and if necessary consider hiring a professional to assist you.
Plugins and Themes that create a database table called "wp_wpsa_subscribe_author"
A database table called wp_wpsa_subscribe_author is created by 1 different WordPress plugin/theme:| Name | Type |
|---|---|
| Wp Subscribe Author | Plugin |
MySQL orphan or zombie database table named "wp_wpsa_subscribe_author" info
A database table called "wp_wpsa_subscribe_author" seems to persist and is not cleanly removed by the following plugin/theme:| Name | Type | |
|---|---|---|
| Wp Subscribe Author | Plugin | Get help with Wp Subscribe Author 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
- wp_posts
- wp_postmeta
- wp_options
- wp_users
- wp_usermeta
- wp_term_taxonomy
- wp_terms
- wp_term_relationships
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