MySQL 5.1.44 is now available on Dotdeb for Debian 5.0 “Lenny” in amd64/i386 flavours.
This is primarily a bug fix release, but please read the Changelog carefully before upgrading.
MySQL 5.1.44 is now available on Dotdeb for Debian 5.0 “Lenny” in amd64/i386 flavours.
This is primarily a bug fix release, but please read the Changelog carefully before upgrading.
m_ueberall
Hm… looks like there’s an upgrade problem (cleaning the cache and retrying didn’t work either):
Preparing to replace mysql-common 5.1.41-3.dotdeb.1 (using …/mysql-common_5.1.44-0.dotdeb.0_all.deb) …
Unpacking replacement mysql-common …
dpkg: error processing /var/cache/apt/archives/mysql-common_5.1.44-0.dotdeb.0_all.deb (–unpack):
unable to create `./etc/mysql/my.cnf’: Invalid argument
Errors were encountered while processing:
/var/cache/apt/archives/mysql-common_5.1.44-0.dotdeb.0_all.deb
Guillaume Plessis
@m_ueberall : please give me the output of the following command :
“ls -al /etc/mysql/my.cnf ; file /etc/mysql/my.cnf”
Which release of Debian are you using?
m_ueberall
# ls -al /etc/mysql/my.cnf ; file /etc/mysql/my.cnf ; cat /etc/debian_version
-rw-r–r– 1 root root 4197 23. Jan 18:09 /etc/mysql/my.cnf
/etc/mysql/my.cnf: ASCII English text
5.0.4
Terry Hobart
I had problems upgrading from my lenny install too. I ran an update after the php5 security post ~ 02/22/2010. Then I changed my sources.lst to dotdeb and ran another update upgrade. I used the default answers to keep my my.cnf etc. After that mysql start failed.
The syslog says ‘FEDERATED’ plugin disabled and mysql.plugin table missing.
Finally the install says mysql-server5.1 & mysql-server were left unconfigured.
Thanks in advance for any advice
Guillaume Plessis
@Terry Hobart : it’s better to install the package maintainer’s version of my.cnf and then backport your changes.
For example, if you upgraded from MySQL 5.0, the former skip-bdb option will prevent the mysql-server-5.1 to start.
Terry Hobart
Thank you SO much. Commenting out that in my my.cnf file worked! I am such a moron! It says right in the comments that the property is dead as of 5.1.some low number.
Thanks again for saving a fools face. I know I should use the new config files, I just had a brain seizure.
beginner
Is there any instruction available how I can upgrade my Debian (including PHP and MySQL). For me it alwyas shows the old version installed after the installation.
A step by step instruction would be great as I am a beginner!
m_ueberall
Disregard my previous postings… the cause of the error must have been that the host file system had been damaged and required a manual fsck run.
Guillaume Plessis
@beginner : Instructions are here : http://www.dotdeb.org/instructions/
After adding the Dotdeb-related entries to your sources.list, just run “apt-get update ; apt-get upgrade”.
jon Bennett
I’m trying to upgrade but keep getting the following error:
Unpacking replacement mysql-server-5.1 …
dpkg: error processing /var/cache/apt/archives/mysql-server-5.1_5.1.44-0.dotdeb.0_i386.deb (–unpack):
trying to overwrite ‘/usr/sbin/mysqld’, which is also in package mysql-server-core-5.1 0:5.1.37-1ubuntu5.1
dpkg-deb: subprocess paste killed by signal (Broken pipe)
any ideas?
Guillaume Plessis
@jon Bennett : Just remove the mysql-server-core package from Ubuntu.
FYI, Dotdeb should work with Ubuntu, but it does not provide any additional support.
jon Bennett
@Guillaume – ok, so I just do apt-get remove mysql-server-core ? Will that wipe out my databases?
J
Guillaume Plessis
@jon Bennett : It should not wipe out your databases without any confirmation from you, but be sure to backup your data before any further manipulation (who said “as usual”? 🙂 )
beginner
I did all steps as in the instructions but it still shows me the old mysql and php versions…not really sure what I am doing wrong…
Cyril
I used Debian etch and i need to upgrade mysql (5.0.32) to 5.1.X
but is not working…
please help me
Guillaume Plessis
@Cyril : take a look at http://archives.dotdeb.org/dists/etch/mysql-dfsg-5.1/5.1.43/ but please consider upgrading to Lenny.
Cyril
Je suis obliger d’upgrader vers Lenny ?
Guillaume Plessis
@Cyril : pas avec les paquets cités précédemment, mais Etch n’étant plus entretenue ni par Debian ni par Dotdeb en terme de sécurité, migrer vers Lenny est une bonne idée.
Cyril
D’accord je vais y penser.
Lorsque je fais la manip “Instruction” je n’ai pas de message d’erreur par contre l’upgrade de mysql ne se fait pas :
“0 packages upgraded, 0 newly installed, 0 to remove and 6 not upgraded.”
Guillaume Plessis
@Cyril : dans votre cas, la manipulation “Instructions” ne sert à rien, Etch ne fait plus partie du dépôt principal. Il faut donc récupérer les paquets un à un (selon votre architecture) à partir de http://archives.dotdeb.org/dists/etch/mysql-dfsg-5.1/5.1.43/
Puis les installer avec dpkg -i *.deb
Cyril
D’accords et comment les installer a la main ?
apt-get install “nom du paquet.deb” ???
Guillaume Plessis
@Cyril : avec dpkg. Un bon manuel d’utilisation, très facilement trouvé sur un moteur de recherche :
http://doc.ubuntu-fr.org/dpkg
Cyril
Merci pour tout (merci de repondre si rapidement)
Je teste tout ca
Cyril
j’y arrive pas, as tu un bon source.list pour etch (je vais essayer l’upgrade de la distrib)
Guillaume Plessis
@Cyril : manipuler le sources.list ne sert à rien, Etch ne fait plus partie des dépôts.
mkdir /tmp/etch
cd /tmp/etch
wget http://archives.dotdeb.org/dists/etch/mysql-dfsg-5.1/5.1.43/binary-i386/libmysqlclient16_5.1.43-0.dotdeb.0_i386.deb
wget http://archives.dotdeb.org/dists/etch/mysql-dfsg-5.1/5.1.43/binary-i386/mysql-client-5.1_5.1.43-0.dotdeb.0_i386.deb
wget http://archives.dotdeb.org/dists/etch/mysql-dfsg-5.1/5.1.43/binary-i386/mysql-common_5.1.43-0.dotdeb.0_all.deb
wget http://archives.dotdeb.org/dists/etch/mysql-dfsg-5.1/5.1.43/binary-i386/mysql-server-5.1_5.1.43-0.dotdeb.0_i386.deb
dpkg -i *.deb
En cas d’erreur : “apt-get -f install”
Cyril
pour lenny je voulais dire
le probleme c’est qu’il veut ca : zlib1g-dev
et je ne l’ai pas
Guillaume Plessis
@Cyril : http://www.debian.org/distrib/archive.fr.html
te donne la liste suivante à ajouter dans ton sources.list pour satisfaire les dépendances :
deb http://archive.debian.org/debian/ etch contrib main non-free
Lance ensuite : apt-get update && apt-get -f install
Rien de bien méchant, juste de la manipulation de paquet. N’hésite pas à chercher et à consulter la documentation de base de la distribution.
Cyril
Merci, je suis en train de mettre a jour vers Lenny.
J’espere que ca va bien se passer.
Cyril
CA Y EST !!!
>> Debian GNU/Linux 5.0 \n \l
Merci pour tout, et a bientôt j’espère ^^
Jan
After the update it says the PHP MySQL version is 5.0.51a but MySQL server version is 5.1.44. Does it matter and how do I get them to match?
I used aptitude update & upgrade.
Guillaume Plessis
@Jan : 5.0.51a is just the version of the libmysqlclient library PHP was built with. Don’t worry about that delta between the client side and the server side, it does not affect the PHP behaviour.
Jan
Great! Thanks, got a little worried… I guess alot of error message sounds omnious, bording doomsday warnings 🙂
oliver
When I try to upgrade from 5.0 to 5.1, I got following error in mysql.err:
100317 18:45:31 [Note] Plugin ‘FEDERATED’ is disabled.
100317 18:45:32 InnoDB: Started; log sequence number 123 1166503368
ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE user ADD column Show_view_priv enum(‘N’,’Y’) CHAR
ACTER SET utf8 NOT ‘ at line 1
100317 18:45:32 [ERROR] Aborting
I found the query in postinst script and run it manually and there is no syntax error.
Have you found the reason of this?
Thanks.
Jaime Silva
Hello there, thanks a lot for this helpful repository… Kudos!
I’m running your MySQL 5.1.45 in a Debian 5.0 (lenny) server.
However I’m getting warnings from PHP because the php5-mysql (5.2.13-0.dotdeb.0) driver is depending on (and using) the old library libmysqlclient15off instead of the newer libmysqlclient16 you provide.
Can this be fixed, please?
Thanks a lot.
Cyril
Merci pour tout, j’ai partagé l’expérience sur mon blog :
http://cyril-leblanc.fr/linux/354-comment-upgrader-debian-etch-4-0-vers-debian-lenny-5-0/