[SOLVED] 9.04->9.10; mysql problem

[greenshirt11]

Upgraded from 9.04 to 9.10 via DVD image.
Did not go completely smoothly but now seems to be ok except for mysql.

Does anyone have an idea on how to proceed?

At boot i get the following messages (same as when doing it manually: /etc/init.d mysql

/etc/init.d/mysql[1562]	0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
/etc/init.d/mysql[1562]	#007/usr/bin/mysqladmin: connect to server at 'localhost' failed
/etc/init.d/mysql[1562]	error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
/etc/init.d/mysql[1562]	Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

When starting manually, the same result:

me@dharana:/etc/init.d$ sudo ./mysql start
 * Starting MySQL database server mysqld                                                         [fail]

Checking the '/etc/init.d/mysql' script, it wants to run '/etc/mysql/debian-start'.
That script wants to source '/usr/share/mysql/debian-start.inc.sh' which isn't there.
Could that be the problem?

Now reading the release notes (a bit late i know ) it says:

In Ubuntu 9.10 MySQL 5.1 has been promoted as the default MySQL server. MySQL 5.0 is still available from the universe repository though. Performing an upgrade via update-manager will correctly handle the transition from MySQL 5.0 to MySQL 5.1. However using a dist-upgrade will not: mysql-server-5.0 will be upgraded instead of being replaced by mysql-server-5.1. If MySQL 5.0 needs to be kept the mysql-server and mysql-client packages should be removed before the upgrade is started.

... and the installed packages are for mysql 5.1.
If that is the problem how would i tackle it while preserving my "old" databases?
Installed:
- mysql-common
- mysql-server-core-5.1
- libmsqlclient16

Not installed?:
- mysql-server-5.1

Should i just install mysql-server-5.1 then?
Or remove 5.1 packages and install 5.0 packages?

Thanks,
F

[greenshirt11]

Re: 9.04->9.10; mysql problem

Solved it by uninstalling:

mysql-admin
mysql-query-browser
mysql-gui-tools-common
mysql-client-5.0
libmysqlclient15off

and installing:

mysql-server
mysql-client

from the logs i see databases upgraded ok.
Running phpmyadmin shows everything as expected.