just installed, first question: is it possible to perform queries and show data on an external MySql database (different than the WP one, but on the same server) . Upon the documentation it doesn't seem to be possible, (or I can't find it) but I would like to be sure. Thanks.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
Yes, we have Multiple DB engine connections support (MySQL, MS SQL, Postgre SQL).
Whether the external database is on the same server or not,
as long as it is not the WordPress database, you can add it as a separate DB connection.
If you input all the relevant credentials for the DB connection, ( such as host, port, password, and so on),
then go for the "Test connection" button. If the Test is successful, your plugin will be able to create datatables on this DB.
Additionaly, you can set this DB connection as default,
but you will also have a dropdown selection for all available DB connections that you added,
Hi,
just installed, first question: is it possible to perform queries and show data on an external MySql database (different than the WP one, but on the same server) .
Upon the documentation it doesn't seem to be possible, (or I can't find it) but I would like to be sure.
Thanks.
Simone
Hi, Simone
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
Yes, we have Multiple DB engine connections support (MySQL, MS SQL, Postgre SQL).
Whether the external database is on the same server or not,
as long as it is not the WordPress database, you can add it as a separate DB connection.
If you input all the relevant credentials for the DB connection, ( such as host, port, password, and so on),
then go for the "Test connection" button. If the Test is successful, your plugin will be able to create datatables on this DB.
Additionaly, you can set this DB connection as default,
but you will also have a dropdown selection for all available DB connections that you added,
during table creation wizard.
Please check more details with a video tutorial here.
Let us know if you have any additional questions
Thanks
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables