Unable to upgrade mysql to 5.5

zurih

Verified User
Joined
Jun 26, 2006
Messages
23
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:

Code:
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
 
It might be that you have unavailable (removed in MySQL 5.5) configuration options set in /etc/my.cnf.
 
All I have in my.cnf is:

Code:
[mysqld]
skip-innodb
query_cache_size = 16M
thread_cache_size = 4M
 
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
 
Last edited:
Back
Top