Still upgrading some of our servers from lenny to squeeze, actually I run into MySQL trouble…

While upgrading from the package mysql-server 5.0.51a-24+lenny5 -> 5.1.49-3 aptitude told me the following:

Mmh, a look into the /var/log/syslog pointed to the following errors:

Many messages at once.. To make a long story short the main problem is this line:

So edit your /etc/mysql/my.cnf and comment the following line (in my configuration it’s line 94):

That’s it, retry to configure the new version and everything will turn out all right.