Archive: Check mysql version?


Check mysql version?
Is there an easy way to check the version (if it's installed that is) of mySQL during an installation?

My package installs mySQL, but I don't want it to overwrite an older version over an updated one.

Any ideas?


Actually, does anyone forsee any problems if I just use the "ifnewer" flag?


You should be able to use the GetDllVersion command and then compare the two versions using VersionCheck function available in the NSIS archive.

Vytautas


I just extracted mysqld-max.exe from the 4.0.18 ZIP file, and no version tab was shown in Explorer, so I'm not sure using the usual NSIS function will work.

Another way is to use the ad hoc MySQL API that lets you check the version number of either the MySQL client or server. The client version looks like this in VB:

Declare Function mysql_get_client_info Lib "libmySQL.dll" () As Long

A similar version if available to query the server for its version number. Take a look at the NSIS System plug-in to learn how to call DLL's (sorry, haven't had time to check it out yet.)

HTH
Fred.