Cannot get mysql client api version to upgrade

Need help installing PHP, configuring a script, or configuring a server? Then come on in and post your questions! We'll try to help the best we can!

Moderator: General Moderators

Post Reply
talksoccer
Forum Newbie
Posts: 3
Joined: Wed Dec 06, 2006 11:31 pm

Cannot get mysql client api version to upgrade

Post 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.
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post 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, ...)?
talksoccer
Forum Newbie
Posts: 3
Joined: Wed Dec 06, 2006 11:31 pm

Thanks for the help

Post 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.
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post 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();
?>
talksoccer
Forum Newbie
Posts: 3
Joined: Wed Dec 06, 2006 11:31 pm

Post by talksoccer »

Thanks. That worked great. Thanks very much for the help.
Post Reply