[solved] Post-9.04, need to reinstall mysql?

[chconnor]

[EDIT]: did the sudo apt-get install mysql-server-5.0 and that fixed it right up. Haven't heard any complaints from the system since.
--------------------------------------------------------------------------------------

Hi - just upgraded 8.10 to 9.04. Apart from a few minor crises, things are going smoothly enough.

On startup, mysqld (which was auto-installed by 8.10 for, I take it, Akonadi/Amarok) [fails] to start.

From /var/log/syslog:

Apr 24 17:46:54 mycomp kernel: [ 31.799499] type=1505 audit(1240620413.791:8):operation="profile_load" name="/usr/sbin/mysqld" name2="default" pid=1996
Apr 24 17:46:54 mycomp kernel: [ 31.836105] type=1505 audit(1240620413.831:9): operation="profile_load" name="/usr/sbin/mysqld-akonadi" name2="default" pid=2000
Apr 24 17:46:54 mycomp kernel: [ 31.861844] type=1505 audit(1240620413.855:10): operation="profile_load" name="/usr/sbin/tcpdump" name2="default" pid=2004
Apr 24 17:47:09 mycomp /etc/init.d/mysql[2608]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Apr 24 17:47:09 mycomp /etc/init.d/mysql[2608]: /etc/rc2.d/S19mysql: line 75: /usr/bin/mysqladmin: No such file or directory
Apr 24 17:47:09 mycomp /etc/init.d/mysql[2608]:
Apr 24 17:47:11 mycomp acpid: client connected from 2818[108:118]

dpkg -l | grep mysql gives:

ii amarok                  2:2.0.2mysql5.1.30-0ubuntu3       easy to use media player based on the KDE 4
ii amarok-common               2:2.0.2mysql5.1.30-0ubuntu3       architecture independent files for Amarok
ii libmysqlclient15off            5.1.30really5.0.75-0ubuntu10      MySQL database client library
ii libqt4-sql-mysql             4.5.0-0ubuntu4             Qt 4 MySQL database driver
ii mysql-common               5.1.30really5.0.75-0ubuntu10      MySQL database common files
rc mysql-server-5.0             5.1.30really5.0.75-0ubuntu10      MySQL database server binaries
ii mysql-server-core-5.0           5.1.30really5.0.75-0ubuntu10      MySQL database core server files

...so I'm seeing "rc" next to the server binaries... hmmm... perhaps i need to reinstall mysql?

If I'm right that i need to reinstall, some pointers on the smart way to do that without messing up existing configs, etc, would be appreciated. Simply apt-get install mysql-server-5.0? Or maybe there's an easy upgrade path to 5.1?

Thanks!

-c