I am trying to delete unused wpDataTables tables from my SQL database using phpMyAdmin. The problem I am having is that the names of these databases do not match, for some reason, inside phpMyAdmin.
For example, the shortcode for one unused table is [wpdatatable id=12] but it has a different number inside phpMyAdmin.
I see both names, inside phpMyAdmin, like this:
wp_wpdatatable_5
but I also see regular names.. I guess the name I gave it inside your plugin. Is there a simple way to identify corresponding tables? Thanks
Here is an example. The shortcode for XXX table is 12 but inside phpMyAdmin it is shown as 7. This makes it difficult to track down the right tables for deletion.
The ID's of the wpDataTables are not the same as ID's of the tables from database. You can take a look at wp_wpdatatables table in database and see relation between wpDataTables and tables from database.
I am trying to delete unused wpDataTables tables from my SQL database using phpMyAdmin. The problem I am having is that the names of these databases do not match, for some reason, inside phpMyAdmin.
For example, the shortcode for one unused table is [wpdatatable id=12] but it has a different number inside phpMyAdmin.
I see both names, inside phpMyAdmin, like this:
wp_wpdatatable_5
but I also see regular names.. I guess the name I gave it inside your plugin. Is there a simple way to identify corresponding tables? Thanks
Here is an example. The shortcode for XXX table is 12 but inside phpMyAdmin it is shown as 7. This makes it difficult to track down the right tables for deletion.
Hi James,
Thank you for your purchase.
The ID's of the wpDataTables are not the same as ID's of the tables from database. You can take a look at wp_wpdatatables table in database and see relation between wpDataTables and tables from database.
So I should be looking at the column called "content"?
Hi James,
You can take a look at column called mysql_table_name