Broke MySQL the other day.

On an impulse I upgraded my personal server from Debian Lenny to Squeeze. All appeared to go well except MySQL didn’t want to start up and only gave the unhelpful error that starting of the MySQL process failed. It being a Friday and with better things to do (beer) I left it with the intention to fix it over the weekend.

Well, I got back to work on Monday and had completely forgotten about working on my server over the weekend thanks to regular house chores and SWOTR but looked into it again today.

A quick look showed that the old mysql-5.0 package may not have been removed completely so I apt-get remove’ed it, after which I got the following:

After this operation, 0B of additional disk space will be used.
Setting up mysql-server-5.1 (5.1.61-0+squeeze1) …
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action “start” failed.
dpkg: error processing mysql-server-5.1 (–configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.1; however:
  Package mysql-server-5.1 is not configured yet.
dpkg: error processing mysql-server (–configure):
 dependency problems – leaving unconfigured
Errors were encountered while processing:
E: Sub-process /usr/bin/dpkg returned an error code (1)

A quick google of the phrase “Package mysql-server-5.1 is not configured yet.” pulled up this website, the long and short is that MySQL 5.1 can not have skip-bdb in its my.cnf file. I loaded up my my.cnf file, found the line with skip-bdb and hashed it out. After a restart of the MySQL service, MySQL started up correctly.

Tagged , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *