Downgrading MySQL

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

Downgrading MySQL

Postby Capono » 07. February 2005 09:35

I have the latest version of Xamp because I need PHP 4.3.10. But I don't like MySQL 4.1.8. Can I downgrade MySQL to 4.0? If yes, how do I do that?

Thanks very much.
Capono
 
Posts: 3
Joined: 07. February 2005 09:31

Re: Downgrading MySQL

Postby Violator » 14. February 2005 10:55

Hi there,

I think I have the same problem.
I can't manage to import my MySQL dumps from my localhost to my server, because my server MySQL version doesn't support the new collation feature of MySQL.

Using Xampp 1.4.11 for Windows, as a solution I figured I could downgrade the MySQL and the MyAdmin packages to a lower version without the collation feature (I do need PHP 4.3.10 for security reasons).

Unfortunately it appeared to be quite difficult to perform this. My knowledge doesn't really measure up to this stuff.

Anyone know a way to get this thing going or just how to make my MySQL dumps with collation information compatible to my online database that doesn't support the collation feature?

Any help would be appreciated!
Greetz
It's not the truth that makes mankind great, it's mankind that makes the truth great -- Confucius
Violator
 
Posts: 1
Joined: 14. February 2005 09:03

Postby Wiedmann » 14. February 2005 11:58

I can't manage to import my MySQL dumps from my localhost to my server, because my server MySQL version doesn't support the new collation feature of MySQL.

You should make your local dumps with "mysqldump.exe" and not with phpMyAdmin.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby zenobia » 22. September 2005 05:46

I can't manage to import my MySQL dumps from my localhost to my server, because my server MySQL version doesn't support the new collation feature of MySQL.


I have the same problem.

You should make your local dumps with "mysqldump.exe" and not with phpMyAdmin.


I tried this but same problem...

I could install WAMPP version 2.1 or 1.1 which use the older version of MySQL but I also would rather not use the older versions of PHP...

I am very new to this and not confident about installing and configuring Apache, PHP and MySQL separately...

Does anyone know another solution? (eg how to 'downgrade' MySQL?)
zenobia
 
Posts: 2
Joined: 22. September 2005 05:31

Postby Capono » 22. September 2005 18:24

I overlooked it at first, but when exporting your database in phpmyadmin, you can choose compatibility with older mysql version.
Capono
 
Posts: 3
Joined: 07. February 2005 09:31

Postby zenobia » 23. September 2005 00:51

brilliant - that works

thanks
zenobia
 
Posts: 2
Joined: 22. September 2005 05:31


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 58 guests