[SOLVED] After Debian upgrade from Lenny to Squeeze, MySQL will not start

fireball1974 · 03-20-2011, 06:14 PM

I just upgraded from Debian Lenny to Debian Squeeze. The upgrade went pretty smoothly. After the upgrade, MySQL does not start at boot time. When I try to start it manually by typing

sudo /etc/init.d/mysql start

it prints .............................failed!

I tried using aptitude to reinstall mysql-server-5.1, but it gave me an error message:
E: Sub-process /usr/bin/dpkg returned an error code (1)

Any idea what I can try?

AlucardZero · 03-20-2011, 06:48 PM

what does the system log say?

Robhogg · 03-20-2011, 07:51 PM

I did a quick Google on this, and found a Debian forum post that may be helpful.

fireball1974 · 03-20-2011, 08:28 PM

This problem is now solved. There were actually multiple problems. First, mysql-server-5.1 was not completely configured. Secondly, I had to comment out a line in my.cnf that says skip-bdb. Third, I had to run mysql_upgrade.

Thank you to everyone who helped!