huh? you can and should be able to upgrade to 4.0.x without too many problems. PHP 4.3.9 has no problems with that, nor will PHPMyAdmin. Moving to mySQL 4.1 will involve more pain as the protocols are vastly different and uses a different php library (mysqli).

For upgrade info see here (

What you might want to do, is back up your v3 db. then install 4.0.x (they can co-exist on the same machine). Configure PHP and PHPMyAdmin to handle the new server as well, then migrate the data to the new server (in the case of MyISAM tables, just copy the folders from the v3 db to the data folder in the v4 db)



From: Mark Benson <[EMAIL PROTECTED]>
Subject: [PHP-DB] PHP, MySQL and phpMyAdmin versions...
Date: Fri, 17 Dec 2004 15:58:08 +0000

I am running MySQL 3.23.49 under Windows NT (XP Home). I also run PHP 4.3.9 on the same server, and use phpMyAdmin 2.6.0-pl2 for admin to my databases. I cannot upgrade to MySQL 4.x becuase apparently the MySQL API included with my PHP distro is not up to date enough to work with the revised security system in MySQL 4. I can't find a newer or better binary distro of PHP4 with a more suitable API, nor do i have the time, facilities or knowledge to bake my own from the source.

Any suggestions, as I really need some of the facilities in MySQL 4.1.x?

P.S. for Matrin Nowland - thanks for the help on the 'ON DUPLICATE KEY UPDATE' thing, I didn't realise it was a new thing in MySQL 4.1.0! <goes away to kick himself ;-)>

Mark Benson

PHP Database Mailing List (
To unsubscribe, visit:

-- PHP Database Mailing List ( To unsubscribe, visit:

Reply via email to