As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #1012448
Deleting Tables in phpMyAdmin
Closed

Comments

  •  2
    James started the conversation

    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

  •  2
    James replied

    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.

  • [deleted] replied

    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.

  •  2
    James replied

    So I should be looking at the column called "content"?

  • [deleted] replied

    Hi James,

    You can take a look at column called mysql_table_name