How to upgrade mysql to 4.1 not 5

I would like to upgrade mysql to 4.1 but not to 5. I've tried this in apt-get, but it always suggesting 5. How do you tell it which version you want?

I'm running a perfect setup Debian Sarge

Thanks.

 

Do it like this:

Code:

apt-get install mysql-server-4.1 mysql-client-4.1 libmysqlclient14-dev

 

perfect!

Exactly what I was looking for. Worked like a charm. Thanks Falko!

 

How do you manage that apt-get suggest mysql 5 for upgrade ?

 

If during the debian sarge install, mysql 4.1 is installed instead of 4.xx , then this happens:

server201:~# mysqladmin -h server1.example.com -u root password yourrootpassword
mysqladmin: connect to server at 'server1.example.com failed
error: 'Lost connection to MySQL server during query'

Unless /etc/mysql/my.cnf is edited and commented out
bind-address = 127.0.0.1:

and mysql is restarted
/etc/init.d/mysql restart

before mysqladmin -h server1.example.com -u root password yourrootpassword
is executed

 

Have a look here: http://www.howtoforge.com/forums/showthread.php?t=4078&highlight=mysqladmin+server1.example.com

 

Maybe he used backports.org?

 

Yes, but with mysql this is passing, with 4.1 it's not.

Anyway, maybie in howto it should be noticed that one who is installing don't have to do that step.