I have created a database and table using PHPMyAdmin.
I'd like to create a table in wpdatatables from this SQL database but it won't recognise the table name. It can only create a table from the core Wordpress SQL database.
If you wish to pull an SQL Query for wpDataTable from another database which is not your default WordPress database, then you have to add another DB connection in our plugin,
and then you will get a dropdown during table Creation Wizard, with the option to choose which DB you will be pulling data for that table. ( You can also change the default DB, if needed)
-
You can connect the plugin to almost any MySQL, MSSQL, and PostgreSQL database using the Separate DB Connection section in wpDataTables,
if you correctly input the details for the connection.
You first have to check if you have the following drivers installed, and activated.
These drivers need to be installed and activated on the server where your WordPress website is.
After you install and activate those drivers, it should work.
If you're not sure how to install the drivers, please reach out to your hosting provider.
The server to which wpDataTables is connecting has its own method of establishing the connection, and we're using PHPs logic of connecting to separate connections.
If there are errors your server returns, those are returned by the server, and only displayed by wpDataTables
- there's no additional log within wpDataTables that would distinctively show you what's behind the error.
-
Let us know how it goes and if you have any questions
I have created a database and table using PHPMyAdmin.
I'd like to create a table in wpdatatables from this SQL database but it won't recognise the table name. It can only create a table from the core Wordpress SQL database.
Hi, Paul
Sorry for the delay
-
If you wish to pull an SQL Query for wpDataTable from another database which is not your default WordPress database, then you have to add another DB connection in our plugin,
and then you will get a dropdown during table Creation Wizard, with the option to choose which DB you will be pulling data for that table. ( You can also change the default DB, if needed)
-
You can connect the plugin to almost any MySQL, MSSQL, and PostgreSQL database using the Separate DB Connection section in wpDataTables,
if you correctly input the details for the connection.
You first have to check if you have the following drivers installed, and activated.
These drivers need to be installed and activated on the server where your WordPress website is.
After you install and activate those drivers, it should work.
If you're not sure how to install the drivers, please reach out to your hosting provider.
The server to which wpDataTables is connecting has its own method of establishing the connection, and we're using PHPs logic of connecting to separate connections.
If there are errors your server returns, those are returned by the server, and only displayed by wpDataTables
- there's no additional log within wpDataTables that would distinctively show you what's behind the error.
-
Let us know how it goes and if you have any questions
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