Page 1 of 1

Cannot get mysql client api version to upgrade

Posted: Wed Dec 06, 2006 11:43 pm
by talksoccer
Hi,

I've installed PHP 5 on a Windows Server 2003 box with IIS6. Followed the tutorials and PHP is working fine, BUT I need version 5.0.27 instead of version 4.1.12 and I cannot get it to upgrade. I downloaded the connector from mysql.com and tried to replace the DLLs and that didn't work. I even tried to copy over the entire directory from another machine which is running 5.0.27 and that didn't work either.

No matter what I try I am stuck at version 4.1.12 of the mysql client API and I really need to upgrade for a specific project I'm working on.

Please help. Is there something I'm missing here? I tried restarting IIS and even rebooting the server and nothing works. What else would I need to do other than replace the 2 DLLs in the connector (1 going to the base PHP dir and the other to the extensions dir)?

Thanks.

Posted: Thu Dec 07, 2006 12:20 am
by volka
Please run a server-wide search for the file libmysql.dll
Where is it/are they located?
Where did you install php and how did you "link" it to IIS (cgi, isapi, ...)?

Thanks for the help

Posted: Thu Dec 07, 2006 8:52 am
by talksoccer
I am using the ISAPI extensions and I've followed all the steps carefully and PHP itself is working fine with IIS, but the problem is the MySQL API version.

Here's where I have the libmysql.dll (on Win server 2003):

c:\php
c:\php\ext
c:\php\php4
c:\winnt\system32
c:\program files\mysql\mysql server 5.0\bin

Should I replace all of these with a newer version? I don't recall seeing this DLL in the connector upgrade download from mysql.com so should I just grab it from my other system which works fine?

Your help is greatly appreciated.

Posted: Thu Dec 07, 2006 9:17 am
by volka
stop the iis
rename or delete all libmysql.dll files except the version in c:\program files\mysql\mysql server 5.0\bin (I'd stuff them in an archive and then delete them - just in case ...).
copy the c:\program files\mysql\mysql server 5.0\bin version to c:\winnt\system32.
search again for libmysql.dll, make sure there are only the two instances in "mysql server 5.0\bin" and system 32.
restart the iis and run

Code: Select all

<?php
echo phpversion(), "\n<br />\n", mysql_get_client_info();
?>

Posted: Thu Dec 07, 2006 9:55 am
by talksoccer
Thanks. That worked great. Thanks very much for the help.