Re: Re: Matching Proper Versions Of PHP and MySQL

zerof wrote:

revDAVE escreveu:

Hello All, I'm a newbie. My server just upgraded to PHP version 5.1.2 from php 4.3.11 MySQL currently is v 4.0.27 Q: What is the oldest - best/safest version of mySQL to use with PHP version 5.1.2.? The reason I mentioned the oldest - is because, for legacy clients, I would like to do the minimum upgrade to ensure best compatibility with legacy code ( mySQL and NON php etc.). If it is OK to stay on mySQL version 4.0.27 ... That would be good to know. Q: Is PHP version 5.1.2 - relatively " stable " version of PHP 5? -- Thanks - RevDave CoolCat@hosting4days.com [db-lists]

The last release version of PHP is 5.2.1. The last relase version of MySQL is 5.0.27. You can use php 5.2.1 with MySQL 5.0.27 without problems. The system is very stable.

That wasn't his question. Stability wise they should be fine. Functionality wise, it depends. The best way to work out the minimum version for your software to work is to check the functions that you're using. eg http://www.php.net/manual/en/function.date-default-timezone-get.php came in at 5.1.0. So depending on what functions you are using, you may need to run a newer version. Mysql 4.0.27 should be ok - but that means you're losing sub-queries (v4.1+) and database functions (v5.0+ I think, maybe 5.1+). Also both are old versions - if you find bugs/have issues, you'll either have to work around them or upgrade - the respective developers will not try to fix bugs in them because they are old (comparatively speaking). -- Postgresql & php tutorials http://www.designmagick.com/