I want help about Compatibility of PHP-MySQL

[kra]

Hello,

I am a very new PHP programmer with very few experience. I need your help regarding following matter.

We have following versions of PHP-MySQL-phpMyAdmin at our local office server with Windows 2003 Server Enterprise Edition.

• php 4.3.10
• mysql-4.0.17
• phpMyAdmin-2.5.3-rc3

Now, our client is going to have dedicated server on Godaddy with Windows 2003 Server Standard Edition with following versions of PHP-MySQL-phpMyAdmin.

• php 5.2.3 or 5.2.5
• mysql 5.0 or higher
• phpMyAdmin 2.7 or higher

Now, please let me know that there will be any compatibility issue with our websites because of PHP and MySQL version differences or our websites will work fine without any bug/error although difference of PHP-MySQL versions.

If this compatibility issue may create any issue with us then what may be the possible solutions for it? Please let me know asap.

Thanks in advance,
KRA

[NogDog]

There are very few coding issues with PHP version upgrades to worry about. The most likely stumbling blocks will be configuration differences, due both to security choices made by the different hosting companies plus the fact that several default settings have changed, most noticeably the dreaded [man]register_globals[/man] setting.

PS: You should probably start with the Migrating from PHP 4 to PHP 5 section of the manual.

[kra]

Thank you very much for your help.

I will refer provided link for PHP migration.

But what about MySQL migration, Any thoughts about it? Please let me know.

Thanks again,
KRA

[NogDog]

I have not run into any problems myself with MySQL version upgrades, but then I've not really had many situations where it was an issue. A couple references to check:

4.0 to 4.1 upgrade
4.1 to 5.0 upgrade