WampServer

I realize that this comes with 5.0, but so many programs are not compatible with this version, that I really need to use mysql 4. Is it possible to uninstall 5 and install and use 4.

Help would be greatly appreciated.

are you refering to not wanting to use the latest verion of mysql, MySQLi? With MySQL v5 you can use both MySQL and MySQLi in your scripts.

[us3.php.net]

[us3.php.net]

If you where not talking about this, what did you mean then?

Here is what I'm running into with one of my programs....

I believe the problem is resulting from this:

[dev.mysql.com]

"Incompatible change: Beginning with MySQL 5.0.12, natural joins and joins
with USING, including outer join variants, are processed according to the
SQL:2003 standard. The changes include elimination of redundant output
columns for NATURAL joins and joins specified with a USING clause and proper
ordering of output columns. The precedence of the comma operator also now is
lower compared to JOIN.

These changes make MySQL more compliant with standard SQL. However, they can
result in different output columns for some joins. Also, some queries that
appeared to work correctly prior to 5.0.12 must be rewritten to comply with
the standard. For details about the scope of the changes and examples that
show what query rewrites are necessary, see Section 13.2.7.1, "JOIN
Syntax"."

That is why I wanted to use 4.x

I have the same problem, can anybody help to replace MySQL5.x by 4.1x plz without downgrading to a previous WAMP version (with either Apache1x or PHP4.x)??

I agree.

I think it's a rather common setup nowadays on web hosts to use PHP5 and MySQL 4. At least that's what all my web hosts do. Using WAMP as a dev server with MySQL5 and a production server of MySQL4 is causing me headaches, Does anyone know a clean way to downgrade MySQL 5 to the latest version of MySQL 4?

If not I'm afraid I will have to abandon the otherwise pretty cool Wampserver for a while until my web host upgrades.

Thanks for any suggestions.

In reponse to this...
Here is what I did and it is working fine.

I' m using version 1.4.4 of wamp with the perl addon which comes with these versions.

Apache version : Apache/1.3.33 (Win32)
PHP version : 5.0.4
MySQL version : 4.1.10a-nt - extension : mysqli

It is still below my server, but it transfers over without any problem.
I suggest trying that.

I spent hours looking for something that was just as nice to use, easy to setup and believe them there isn't anything out there, so use this version and you will be pleased.

Hope this helps.



Kim Sample