| Author |
|
Mitron
Joined: 04 Jan 2006
Posts: 63
|
 Posted: Wed 30 Jan '08 11:02 Post subject: MySQL 5.0.51a binaries released |
 |
|
| Looks like MySQL finally released a Windows binary release, 5.0.51a. Nice, anyone load this one up yet? |
|
| Back to top |
|
Smitty
Joined: 03 Jan 2008
Posts: 197
|
| Posted: Wed 30 Jan '08 17:16 Post subject: |
|
|
| I upgraded my servers with it last night. Looks like everything is running great. |
|
| Back to top |
|
Mitron
Joined: 04 Jan 2006
Posts: 63
|
| Posted: Thu 06 Mar '08 23:27 Post subject: |
|
|
I think this has been covered in the past and I think I know the answer but, I just upgraded to MySQL 5.0.51a and noticed phpinfo has the wrong Client API header version listed. Is this due to the php_mysql.dll and the php_mysqli.dll being compiled with MySQL 5.0.45 from the PHP folks?
If so I guess I'll need to grab a snapshot or have them recompiled against 5.0.51a? |
|
| Back to top |
|
Steffen
Moderator
Joined: 15 Oct 2005
Posts: 3092
Location: Hilversum, NL, EU
|
| Posted: Fri 07 Mar '08 8:16 Post subject: |
|
|
Be sure to rmove all the old instances libmysql.dll and replace them with the new one.
Steffen |
|
| Back to top |
|
Mitron
Joined: 04 Jan 2006
Posts: 63
|
| Posted: Fri 07 Mar '08 9:56 Post subject: |
|
|
Yeah, I'm pretty sure I did all that. Did a search for the file, changed all the old ones to a .bak file, then copied the new one into each location. That fixed a couple things but the Client API header version is still off.
I even tried grabbing the latest php snapshot, but it's still compiled against 5.0.45 or so it seems by phpinfo().
| Code: |
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.51a
Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port 3306 3306
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off
mysqli
MysqlI Support enabled
Client API library version 5.0.51a
Client API header version 5.0.45
MYSQLI_SOCKET /tmp/mysql.sock
Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off
|
I went ahead and downloaded Visual C++ 2005 Express and am currently reading up on compiling Apache, PHP and MySQL on Windows. So eventually I'll probably add the mod_db mysql support and the latest php_imagick.dll if I can figure all that out.
I have compiled MySQL before using 2005 Express so hopefully the rest will go just as easy. Somehome I kinda doubt it.  |
|
| Back to top |
|
Mitron
Joined: 04 Jan 2006
Posts: 63
|
| Posted: Sat 15 Mar '08 11:52 Post subject: |
|
|
Ok, I finally got VCE 2005 installed and updated, the SDK installed and configured with VCE and began building PHP 5.2.5 for MySQL 5.0.51a. I installed MySQL and grabbed the source (just in case I needed it).
I found I didn't really need the win32build.zip file if I already had the zip.zip package. I also noticed the zip.zip package seemed to be missing the newer include and lib files for MySQL so I replaced those before building PHP.
I added the php_build\bin to the PATH, php_build\include to the INCLUDE and php_build\lib to the LIB variables in System Properties -> Advanced -> Environment Variables -> System Variables.
I tried a number of configure options and found the only one I could get to work was:
| Code: | buildconf
cscript /nologo configure.js --enable-snapshot-build
nmake snap
|
I then copied the php_mysqli.dll over to the system that produced the info above and I'm still getting the same output in phpinfo() where the Client API library and header are different versions.
Has anyone else run into this? |
|
| Back to top |
|
