MYSQL: Default Basic Table Structure WordPress

If you use WordPress and have tested some plugins and removed them later, it is possible that you have much waste tables still inside your database.

  • First do Database Backup with MySQL DUMP
  • Then check it enter the mysql console as your mysql admin user and do:

$mysql -u mysqladminusername -p

mysql > use databasename;

mysql > show tables;

System echo:

+---------------------------+
| Tables_in_wordpressdatab  |
+---------------------------+
| wp_commentmeta            |
| wp_comments               |
| wp_links                  |
| wp_options                |
| wp_postmeta               |
| wp_posts                  |
| wp_term_relationships     |
| wp_term_taxonomy          |
| wp_termmeta               |
| wp_terms                  |
| wp_usermeta               |
| wp_users                  |
+---------------------------+
12 rows in set (0.00 sec)

If this default structure is seen the plugins tables are removed correctly.

If not do, delete waste tables with:

mysql > drop wp_old_plugin_table_name;

logout with “quit” and test the WordPress Blog with logins and handling.

Remark: You never know what changes plugins inside your database do, the authors are unknown by yourself! Less is more secure!

More Details of WordPress Tables Basics Details