Archive: Connecting to a remote MySQL Server from NSIS


Connecting to a remote MySQL Server from NSIS
Hello everyone,

I am currently setting up an intaller that updates an FTP folder and a MySQL DB.

What I need to update the MySQL DB, is a way to connect, identify, and send a query to a remote host.

- I tried searching for plugins but could not find any.

- Doing it through a PHP page is not possible in my case, as the amount of data is huge

- I think it should be possible to connect via a command line MySQL client using Exec.
However, I could not find such softwares in Google.

Is it possible? and do you know any software that would do the trick?

- Any other ideas?

Thanks in advance,
Loic


You could access the mysql remote host via the putty tools. In the wiki is an example on how this was done the other way (download and import database from remote to local host), so maybe this could help you:

http://nsis.sourceforge.net/wiki/Sil...port_installer