Unable to upgrade mysql to 5.5

[zurih]

Hi, I just tried to upgrade to mysql 5.5 using custombuild, but I received some errors.

I following this guide: http://help.directadmin.com/item.php?id=240

First, it told me I miss 'libaio', so I've installed it via yum.
When I ran it again, it still showed my that it's missing.
Then I've noticed it's looking for it in /usr/lib/, and for some reason it installed in my centos6 in just /lib/, so I copied the file into /usr/lib/

Ran the installation again, it seemed to run fine at first, but at the end I received this:



Stopping mysqld ...
Shutting down MySQL. SUCCESS!
Upgrading MySQL 5.0 to 5.5
Preparing... ########################################### [100%]
1:MySQL-devel ########################################### [ 25%]
2:MySQL-shared ########################################### [ 50%]
3:MySQL-server ########################################### [ 75%]
4:MySQL-client ########################################### [100%]
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/xxx.xxx.com.pid).
Giving mysqld a few seconds to start up...
Looking for 'mysql' as: /usr/bin/mysql
Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Running 'mysqlcheck with default connection arguments
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
cp: `/usr/lib/libmysqlclient.so' and `/usr/lib/mysql/libmysqlclient.so' are the same file
Restarting MySQL.
ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/xxx.xxx.com.pid).
It is recommended to do "./build php n" after MySQL update.


I don't even have the file /var/lib/mysql/xxx.xxx.com.pid.

Any idea?
Right now I rolled back as I was before I tried to upgrade.

Thanks

[smtalk]

It might be that you have unavailable (removed in MySQL 5.5) configuration options set in /etc/my.cnf.

[zurih]

All I have in my.cnf is:



[mysqld]
skip-innodb
query_cache_size = 16M
thread_cache_size = 4M

[smtalk]

All I have in my.cnf is:



[mysqld]
skip-innodb
query_cache_size = 16M
thread_cache_size = 4M


Have you checked MySQL error log? /var/lib/mysql/*.err

[zurih]

Have you checked MySQL error log? /var/lib/mysql/*.err

it was "skip-innodb"
I commented it and now it works fine
thanks for your help :)

[zurih]

hmm... in phpMyAdmin I'm getting this message:
Your PHP MySQL library version 5.5.18 differs from your MySQL server version 5.0.91. This may cause unpredictable behavior.

Any idea?
Already tried ./build update & ./build php n, didn't help

"rpm -qa | grep MySQL" gives me this:
MySQL-devel-5.5.18-1.linux2.6.i386
MySQL-shared-5.5.18-1.linux2.6.i386
MySQL-client-5.5.18-1.linux2.6.i386
MySQL-server-5.5.18-1.linux2.6.i386

EDIT: also tried ./build mysql, didn't help
EDIT: solved it, just needed to relog phpMyAdmin

[scsi]

what does relog mean?

[zurih]

relog = logout and then login