Downgrading Mysql

[ReN]

Greetings all,

i have a rather interesting problem , i need to downgrade the version directadmin uses to 3.23 tree, no db's have been created using the 4.1 tree it is currently using , is this at all posible ..

ReN

 

[jmstacey]

If you don't have any databases then yes. Why is what puzzles me.
Simply install the version you want for your Operating System. The method would vary from OS to OS.
For example on FreeBSD you can simply download a precompiled package (if you could find one).

 

[ReN]

Reason is , i cant find any info about how to easily upgrade databases from 3.23 to 4.1, or scripts to do it automatically, or even a howto guide. If you have anything like this it would be appreciated.

What if anything do i need to edit in directadmin files to get 3.23 working??? and why would i need a precompiled version...


ReN

 

[jmstacey]

Have you read this?
http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html

Upgrade to 4.0 then after thats working you can upgrade to 4.1. At least in the 4.0 to 4.1 upgrade passwords are the only issue but there is an easy solution.

Since DirectAdmin doesn't depend on MySQL for operation there aren't any files that would need to be edited besides /usr/local/directadmin/conf/mysql.conf
which contains the da_admin login information
and the startup script.
The first can be fixed following this guide:
http://help.directadmin.com/item.php?id=45

 

[ReN]

ok , as you know, 4.1 is installed on new directadmin systems...

my old system used 3.23 and i need to import these dbs and upgrade them, what steps need to be take in this case.

sorry took me a while to get to the point

ReN

 

[jmstacey]

Yes that link I gave you contains information on upgrading your databases to 4.0
For example converting your isam tables to myISAM.
Give it a read

I would suggest upgrading to MySQL 4.0 on your old server. Once everything is working on your old server move all the databases to your new one and enable "old_passwords" on your MySQL 4.1 installation.