Okay
  Public Ticket #1322698
Connect to Remote MySql DB
Closed

Comments

  • lee2ulyn started the conversation

    Hi,

    Can I create some tables using my wordpress Database and others using a remote mysql database.  

    I have the need to be able to create tables from both.

    Thanks,

    Tommy

  • [deleted] replied

    Hi Tommy,
    Thank you for the inquiry.

    Unfortunately something like that is not possible at the moment. We have plans to add feature so you can set up separate MySQL connection per table in on of the future updates but I don't know when it will be.

  • lee2ulyn replied

    Milos,


    Thanks for the quick response. I actually use the Plugin now but for some reason it was not letting me enter a regular support ticket.

    I know you don't know when for sure..  but is it in development (like possible next big update) or just on the list?

    If it is going to be a long time is possible to run two instances of the plugin (doubt it) but figured I would ask.

    Thanks,

    Tommy

  • [deleted] replied

    Hi Tommy,

    "Thanks for the quick response. I actually use the Plugin now but for some reason it was not letting me enter a regular support ticket."

    - Probably you'll have to enter purchase key of the plugin and you'll be able to post a ticket.

    "I know you don't know when for sure..  but is it in development (like possible next big update) or just on the list?"

    - It's now just in the backlog and we don't have specific ETA for this feature at the moment.

    "If it is going to be a long time is possible to run two instances of the plugin (doubt it) but figured I would ask."

    - Unfortunately something like this is not possible because there would be conflicts between classes  and functions with the same name. Probably it would be easier to create this feature as custom solution than to have two instances of the plugin.

    For now something like this can be achieved with some custom PHP coding. If you are familiar with PHP you can take a look at ../wp-content/plugins/wpdatatables/source/class.sql.php where is the logic for this feature.

  • lee2ulyn replied

    Thanks again for the quick reply.. I will check out the PHP..


    Tommy