How to migrate from MySQL 3 to MySQL 4? Must I reinstall PHP?

[guarriman]

Hi.

I've got installed PHP and MySQL from sources at '/usr/local/php' and '/usr/local/mysql'.

I want to install MySQL 4 at '/usr/local/mysql4', listening in another port. Must I install PHP again? Or must I only change my PHP configuration to talk in the new MySQL port?

Thank you very much.

[jamie]

hi,

afaik you will only need to reconfigure php if you want to use the newer mysql client libraries which come with mysql4.

have a look at your ./configure command in phpinfo(). if it says '--with-mysql' then you are using php's own mysql libraries. if you have a path ('--with-mysql=/usr') then it is mysql's libraries, in which case you may want to reconfigure to use the newer client libraries with mysql4

i used php's built-in mysql client libraries for years with mysql4 and 4.1 with no problems.

i am no expert though, perhaps better to wait for a wiser man to comment?

further info: [us.php.net...]

james