mysql 4.0 needed

Problems with the Linux version of XAMPP, questions, comments, and anything related.

mysql 4.0 needed

Postby tassoman » 08. May 2006 09:33

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.
tassoman
 
Posts: 6
Joined: 08. May 2006 08:40

Postby capitalfellow » 09. May 2006 15:34

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 ?
User avatar
capitalfellow
 
Posts: 60
Joined: 19. July 2005 01:10
Location: Charlotte, NC USA
Operating System: OS X

Postby tassoman » 09. May 2006 15:46

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?
tassoman
 
Posts: 6
Joined: 08. May 2006 08:40

Postby capitalfellow » 09. May 2006 16:24

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.
User avatar
capitalfellow
 
Posts: 60
Joined: 19. July 2005 01:10
Location: Charlotte, NC USA
Operating System: OS X

Postby tassoman » 09. May 2006 16:57

I'm worried about collation and php connection module... :?
tassoman
 
Posts: 6
Joined: 08. May 2006 08:40

Postby capitalfellow » 09. May 2006 17:50

Can you explain with more detail ?
User avatar
capitalfellow
 
Posts: 60
Joined: 19. July 2005 01:10
Location: Charlotte, NC USA
Operating System: OS X

Postby tassoman » 10. May 2006 09:28

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.
tassoman
 
Posts: 6
Joined: 08. May 2006 08:40

Postby capitalfellow » 10. May 2006 16:30

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.
User avatar
capitalfellow
 
Posts: 60
Joined: 19. July 2005 01:10
Location: Charlotte, NC USA
Operating System: OS X

Postby tassoman » 10. May 2006 17:00

Ok I got it. Thanks for help :)
tassoman
 
Posts: 6
Joined: 08. May 2006 08:40

mysql 4.x

Postby tschodt » 19. May 2006 16:58

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.
tschodt
 
Posts: 3
Joined: 19. May 2006 16:15
Location: UK

Postby scranmer » 06. June 2006 11:28

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!
scranmer
 
Posts: 26
Joined: 20. May 2004 14:59
Location: UK, Southport

Postby capitalfellow » 07. June 2006 19:25

Why did you replace the version of MySQL that comes in XAMPP ?
User avatar
capitalfellow
 
Posts: 60
Joined: 19. July 2005 01:10
Location: Charlotte, NC USA
Operating System: OS X

Postby scranmer » 24. July 2006 18:21

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.
scranmer
 
Posts: 26
Joined: 20. May 2004 14:59
Location: UK, Southport

Re: mysql 4.x

Postby tschodt » 30. October 2006 13:47

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.
tschodt
 
Posts: 3
Joined: 19. May 2006 16:15
Location: UK


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 21 guests