SQL for another database

  • Resolved tashword

    (@tashword)


    9 years, 5 months ago

    Hi Eli,

    I had this working perfectly on our test site but am now having trouble on our real site. I know next to nothing about MySQL so apologies if I use incorrect terms.

    basically I need to get the code to refer to another database – ie it is on the same hosting and in the same MySQL but is not part of the WP database.

    When I create a report, the list of folders does not show the relevant fields to choose. I tried entering the required table name in the code that shows in ‘create a report’ but it didn’t work.

    Can I direct the plugin to that other database somehow? If not, can I migrate the other database into the plugin’s view (very nervous asking that one!)?

    Thanks,

    Tash

    https://www.ads-software.com/plugins/elisqlreports/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Eli

    (@scheeeli)

    You can use this plugin to write a query for any table in active WordPress database. It is not current possible within this plugin to query tables from another database.

    The easiest solution would be to import the tables you need to access into the database where your WordPress is already installed.

    Aloha, Eli

    Thread Starter tashword

    (@tashword)

    Thanks Elis.

    I copied across the database and the plugin is working perfectly now. Thanks again,

    Tash

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘SQL for another database’ is closed to new replies.