Apache Friends Support Forum

Hi all,
i must develope php apps with mysql 4.0 version of database.

Should I install an older version of xampp than the lastest?

Thanks in advance.

The 5.0 version should be backwards compatible. As long as your development doesn't take advantage of features in 5.0 that aren't in 4.0 you should be able to move your code to the older database.

Or are you using a PHP framework that doesn't support MySQL 5.0 connectivity ?

the production server runs php 4.3.? and mysql 4.0.2? so i suppose my need is to develope for the older than 4.4.1 framework? is it?

I agree with you. You probabaly want to download version 1.4.14. The main difference between MySQL 4.1 and 4.0 is the ability to use sub-selects.

I'm worried about collation and php connection module...

Can you explain with more detail ?

I would mean that after php 4.4.1 they upgraded mysql connection module to get connected to mysql 4.1 and 5.0 that changes from the 4.0 mysql module.
There's some problem managing mysql connections by different encryption of passwords.

More, mysql 5.0 adds new features about language encoding of tables. So we get that the default collation is utf8_unicode for 5.0 and latin1 for 4.0

Because i need to develope the sql code also, i would give away the much more compatible code with older versions, that are the most installed until now.

Ah, I've had the problem too. Here's the solution.

If you're running PHP 4.4.1 and need to connect to MySQL 4.1 or MySQL 5.0 check phpinfo() and see if the with-mysqli was compiled in. Then PHP can use the mysqli_ functions to use the new PHP interface into the later versions of MySQL.

If you're running PHP 4.4.1 and need to connect to connect to MySQL 4.0 check phpinfo and see if the with-mysql was compiled in. Then PHP can use the mysql_ functions to use the PHP interface with the new password function built into MySQL.

If you need PHP to connect to MySQL 4.0 or higher using the mysql_ functions AND the older password scheme that was also in use in MySQL 3.2.x then add this to the my.cnf that the server uses on startup under [mysqld] :

old-passwords=1

and restart MySQLd.

I don't know about the collation or language issues but I imagine if you read through the MySQL documentation there are settings you can make either at the database or table level to make them act in the behavior of the older versions of MySQL just as you can with passwords.

Ok I got it. Thanks for help

I needed xampp to co-exist with an application that requires mysql 4.x (it uses a database with a table with a column named "trigger" and a table named "trigger").

I just used xampp 4.1.15 - solved my problem.

The application with the norteh table/column names will be made mysql 5 compliant later this year apparently.

I guess I could have installed xampp 1.5.2 with mysql 5 using an alternative TCP/IP port (leaving port 3306 for the mysql 4 running outside xampp control) but I only realised later. o_O.

Now, if the xampp installation asked if you wanted alternative TCP/IP ports for mysql and apache - one could install and test a new version of xampp without messing with an existing (running) xampp installation.

There is always one and its usually me...

I now need to do the same sort of thing. I have a test environment in Windows and its been crashing allot lately so I have got really p***ed and am now doing what I should from the start and setup and used everything under Linux.

HOWEVER...
the live server is setup with mysql 4.1 & all the latest other stuff (apache 2.2, php 5.1). For Windows I remember just downloading the latest mySQL and basically replacing the xampp folder but this is not possible in the Linux version any ideas? I read the above but got totally lost.

Cheers

Si.

PS take it easy on me Im a Linux Newbee (Suse 10) - Ive still not got out of 800x600 screen mode yet!

Why did you replace the version of MySQL that comes in XAMPP ?

I needed the latest version of PHP (5) but am still using 4.1

so any idea on how we downgrade/setup mysql

cheers

Si.

tschodt wrote:... I could have installed xampp 1.5.2 with mysql 5 using an alternative TCP/IP port (leaving port 3306 for the mysql 4 running outside xampp control) but I only realised later. o_O.

Now, if the xampp installation asked if you wanted alternative TCP/IP ports for mysql and apache - one could install and test a new version of xampp without messing with an existing (running) xampp installation.

Once you've worked with each component (Apache, mysql, etc.)
it becomes clear that changing port numbers and service names is relatively straight-forward.
It would still be useful if one could select alternative port numbers and service names during setup.

Only xampp-control.exe does not readily work with an alternative configuration.