wpsnoop: Origins of the WordPress database table "wp_woocommerce_product_batch"
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_woocommerce_product_batch come from?
This page provides some information on the wp_woocommerce_product_batch table and a list of plugins and themes where it may have originally come from.
Can the wp_woocommerce_product_batch 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_woocommerce_product_batch table you can certainly delete it with phpMyAdmin BUT we would suggest renaming the table to something else like old-wp_woocommerce_product_batch and make sure your WordPress installation still works :)Assuming everything seems ok after renaming the table you can safely DROP old-wp_woocommerce_product_batch 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_woocommerce_product_batch"
A database table called wp_woocommerce_product_batch is created by 1 different WordPress plugin/theme:| Name | Type |
|---|---|
| Product Batch for WooCommerce | Plugin |
MySQL orphan or zombie database table named "wp_woocommerce_product_batch" info
A database table called "wp_woocommerce_product_batch" seems to persist and is not cleanly removed by the following plugin/theme:| Name | Type | |
|---|---|---|
| Product Batch for WooCommerce | Plugin | Get help with Product Batch for WooCommerce 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