Upgrade mysql

[bianco]

Hello

I m french and i don't speak very english ...
I have an account plesk 100 domains names with my friend who bye it, we have this server together and we are newbies, I reecently upgrade plesk to the plesk control panel 8.0 by myself with the updater ...

How can I upgrade MySQL, I have 4.1.11-Debian_4sarge7-log installed, my friend instal it but he is not here to help me to upgrade to the 5 version, maybe he is in holidays and he doesn't anwers me, and I would like to upgrade sql to the last version of mysql, how can i do it?

I use Private Shell to reach the server by ssh, I have the right login and pass that he gives to me, I don't find the information to update even i search with google, please help !

 

[danliker]

i suggest you to update debian sarge to etch first...

as a first step update your system to the newest versions of sarge
"aptitude update && aptitude upgrade"

after this you need to edit your /etc/apt/sources.list
change all "stable" or "sarge" to "etch" and do "aptitude update && aptitude dist-upgrade"

if this have worked well you can install mysql5 with "apt-get install mysql-server-5 mysql-client-5"
and if you like to have php5 "apt-get install psa-php5-configurator"

 

[bianco]

Thank you for your response but it doesn't work at all...

>as a first step update your system to the newest versions of sarge
>"aptitude update && aptitude upgrade"

done, it is ok

>after this you need to edit your /etc/apt/sources.list
>change all "stable" or "sarge" to "etch" and do "aptitude update && aptitude dist-upgrade"

done, it is ok
here is my old /etc/apt/sources.list:

#deb http://debian-mirror.dedibox.fr/debian/ stable main
#deb-src http://debian-mirror.dedibox.fr/debian/ stable main

deb http://security.debian.org/ sarge/updates main


deb http://ftp.fr.debian.org/debian/ sarge main
deb-src http://ftp.fr.debian.org/debian/ sarge main

## This is temporary appended by Autoinstaller from SWsoft for
## specify source of product's packages for APT.
deb https://autoinstall.plesk.com/debian/PSA_8.6.0 sarge all

the new one is:

#deb http://debian-mirror.dedibox.fr/debian/ etch main
#deb-src http://debian-mirror.dedibox.fr/debian/ etch main

deb http://security.debian.org/ etch/updates main


deb http://ftp.fr.debian.org/debian/ etch main
deb-src http://ftp.fr.debian.org/debian/ etch main

## This is temporary appended by Autoinstaller from SWsoft for
## specify source of product's packages for APT.
deb https://autoinstall.plesk.com/debian/PSA_8.6.0 etch all


>if this have worked well you can install mysql5 with "apt-get install mysql-server-5 mysql-client-5"

Here is my error message:
E: Couldn't configure pre-depend psa-8.6.0 for psa-api-rpc, probably a dependency cycle.

and

E: Impossible de trouver le paquet mysql-server-5 ( don't find the paquage mysql-server-5)
root@servidor:~#


How can i do to find and install this paquage? Thanks for help!

 

[danliker]

can you post the output of
"aptitude update && aptitude upgrade"
is there everything ok ?

 

[bianco]

Ok i just change : apt-get install mysql-server-5 mysql-client-5

by

apt-get install mysql-server-5.0 mysql-client-5.0

and every works fine!

Thanks you very much Danliker for your help!