Link to another MySQL database

Hi,

Thanks for contacting us here about this extension.

I need to link to a different MySQL database, on the same server, and it is not apparent how to do this.

It seems I can only link the the Joomla System database, and that, or course, contains no table information that I would want to make public.

Please let me know how to do this.

To create a table from a database on another site, you need to connect to that database to copy it to the database on your site.
You can connect in the following way https://phoenixnap.com/kb/connect-mysql-with-php
You will then create a table from the copied database using the 'Database Table' function.

If impossible, then I would request a refund (purchased April 24, 2023), as your extension is not practically useful for me, as table data resides elsewhere, as it should.

Please drop us a billing ticket at: https://www.joomunited.com/support/helpdesk/createticket, our admin will help you.

Cheers,

Not a great solution. Copying data from one database to another (and especially the Joomla system DB), is not what I'm after in a Joomla data table display extension. Yes I could write connect and copy code in PHP, but am looking for simplicity and automation, and don't want to get into the complexity of data replication - maintaining one changing data store is challenge enough. The extension really needs to easily be able to link to SQL data sources beyond the Joomla system db.

Hi,

Thanks for your response.

You can utilize Cron job to schedule automatic backups of a db-table in another database. Meanwhile, Droptables will refresh the page automatically when your db-table is updated.
You don't need to copy the entire source database, just the necessary tables.

We cannot create a feature that links to another database due to potential security issues.


Thanks a lot!
Cheers,