Hey everyone!
With the Labour Day holidays coming up, we’d like to let you know about our upcoming working hours:
Thursday, May 1st: Our team will be off during Labour Day.
Friday, May 2nd: We'll also be off for an extended holiday break.
We’ll be back on Monday, May 5th, ready to respond to all messages received during this time.
In the meantime, if you need help, feel free to:
-
Use the support widget on the bottom right of our websites (Amelia and wpDataTables) — our AI-powered assistant is available 24/7 and can help with many common questions.
-
Visit our documentation, articles, or YouTube channels for quick answers and step-by-step guides.
https://www.youtube.com/@AmeliaWordPressBookingPlugin/videos
https://www.youtube.com/@wpDataTables/videos
Thank you for being so understanding, and we hope you enjoy the long weekend!
Good da,
I have a lot of data store in an MySQL database on an VPS.
Given it's 100k upto several million of records, depending on the table I'm using, I need a strong VPS for sever side processing.
For a lot of stuff, I work directly on the database via https://tableplus.com/ and connect via openssh.
Now I realized I cannot connect the same way with wpDataTables via 'Separate DB connection' to the external MySQL database. For webhosting solutions this was working geat.
You may have any hints, how I can solve this issue and get the connection done via wpDataTables as well?
Thanks for your great support. :)
Felix
Attached files: MySQL connection to VPS.png
MySQL connection to VPS via wpDataTables.png
Hi Felix,
We were advised by our devs on this, in regards to any External DB connection that uses SSH.
At this time, it is not possible to achieve this with built-in options.
You would have to make a custom workaround, that would not be covered by our support at this time.
Here's one resource that you can check out if you wish to try:
https://help.pythonanywhere.com/pages/AccessingMySQLFromOutsidePythonAnywhere/.
MySQL databases on PythonAnywhere are protected by a firewall, so external computers can't access them.
There may be a way of doing this through VPN, but you'd need to have the tunnel constantly opened for something like that.
I don't exactly know how to do it, but if you are willing to explore this option, I'm sure you'll be able to find some useful info.
We hope this helps.
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
Dear Miloš,
Well noted and thanks for your feedback.
So, if I understood correctly, there are the following options:
Have a nice day
Felix