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
 

smtalk

Administrator
Staff member
Joined
Aug 22, 2006
Messages
8,339
Location
LT, EU
It might be that you have unavailable (removed in MySQL 5.5) configuration options set in /etc/my.cnf.
 

zurih

Verified User
Joined
Jun 26, 2006
Messages
23
All I have in my.cnf is:

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

zurih

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