Downgrading MySQL to 4.1

pucky

Verified User
Joined
Sep 9, 2006
Messages
795
We just setup a new server, FreeBSD 6.1 + DA and the version of MySQL installed is MySQL 5.0.22 by DA.

We will be migrating cPanel accounts to DA but our existing version of MySQL is 4.1.x on Cpanel and we dont want to have MySQL issues on DA due to imcompatabilities with 5.x.

Should we uninstall MySQL 5 via ports then install 4.1 how should we downgrade MySQL?
 

HH-Steve

Verified User
Joined
Oct 8, 2004
Messages
59
Location
Australia
Here is what I got from a search of this site:

Dump your existing databases:

/usr/bin/mysqldump --create-options --compatible=mysql40 --all-databases --force --user=root --password=123456@@ > sql.sql

(Modify command as needed)


Install the desired 4.x version of mysql:

http://help.directadmin.com/item.php?id=106

You will have to remove the old databases and then restore them from the backups you made.

Thats it. This is more of a guide than a step by step but it should be enough to get you going.

----------------------------------

Info taken from the following thread:

http://www.directadmin.com/forum/showthread.php?s=&threadid=14568


Steve
 

HH-Steve

Verified User
Joined
Oct 8, 2004
Messages
59
Location
Australia
pucky said:
Nobody knows huh? Interesting that nobody should.
Have some patience mate, you only posted the origional message 2 hours ago and a simple search revealed everything you needed to know.

Steve
 
Top