HellI, Roberto,

Here is a workaround how you can change the DB connection on existing SQL tables in our Plugin.

For each table, during creation we have to manually select the DB connection from the dropdown;

and the only way to change that after the tables were already made by our plugin,

is to go in the database where your WordPress is,

there find our plugin's database table named 'wp_wpdatatables'.

( the wp_  is the default WordPress Database table prefix,   on your site's database that table prefix might be different, but it should be easy to recognise, all tables would have the same DB prefix,

so check for "yourTablePrefix_wpdatatables")

This table holds the details and settings for each table from our plugin.

If you wish to sort it by table type, you can hit the Header of column 'table_type' and just look for 'mysql' type tables,

or you can do a "search" on wp_wpdatatables to only show this table type.

Then check under the "connection" column, here the "external DB connection" name is set.

You can edit that field for all MySQL tables you need from our plugin and change the DB connection name.

Under the "content" you will also see the SQL Query used for each table,

and of course, in the ID field, it will show each wpDataTable's ID,  as they would show on the Shortcodes.

Here is an example screenshot from a user's database that has two different external DB Connections and how that looks in the table's data :

Let me know if that helps.

Thank you.

Hi Roberto,

I am delighted to hear that this has been resolved. Thank you for letting us know. 

Anything else that we could assist with, please don't hesitate to create new tickets.

Have a great day! :)