upgrade from 5.0.45-community MySQL to 5.0.77-community MySQL

[shann]

Hello guys,

Our old server is running with 5.0.45 and new server is with 5.0.77 and we transferred few sites to new server and we are getting database error. Can we upgrade from 5.0.45 to 5.0.77 using whm or cpanel script?

Thanks in advance.

[cpanelkenneth]

Hello guys,

Our old server is running with 5.0.45 and new server is with 5.0.77 and we transferred few sites to new server and we are getting database error. Can we upgrade from 5.0.45 to 5.0.77 using whm or cpanel script?

Thanks in advance.

It sounds like your MySQL updates are disabled. MySQL 5.0.77 has been available in all branches since June 2, 2009 Try executing /scripts/mysqlup directly via the command line.

[shann]

Thanks a lot Kenneth, but it is not helping, how do I verify that mysql update is disabled or not?

root@server[~]# /scripts/mysqlup
MySQL Setup Script Version 7.0
Fetching http://httpupdate.cpanel.net/mysqlin...E/cPpkgversion (0)....@209.188.92.54......connected......receiving...100%......Done
Loaded cPPkgs::MySQL ok!
Install Complete
root@server [~]# mysql -v
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 15053353
Server version: 5.0.45-community MySQL Community Edition (GPL)

Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

[cpanelkenneth]

Are you using FreeBSD or Linux?

[shann]

Linux and updated now, but not starting mysql.

Installing /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.so
Appending installation info to /usr/lib/perl5/5.8.8/i386-linux-thread-multi/perllocal.pod
CAPTTOFU/DBD-mysql-4.011.tar.gz
/usr/bin/make install UNINST=1 -- OK
perlmod--Install done
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
Unable to reset root MySQL password. at /scripts/securemysql line 154.
Install Complete
root@server [/scripts]# mysql -v
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
root@server [/scripts]# /etc/init.d/mysql restart
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL. ERROR! Manager of pid-file quit without updating file.
root@server [/scripts]#
root@server [/scripts]#
root@server [/scripts]# mysql -v
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
root@server [/scripts]# ps -ef | grep -i mysql
root 30900 8195 0 09:06 pts/0 00:00:00 grep -i mysql
root@server [/scripts]# /etc/init.d/mysql restart
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL. ERROR! Manager of pid-file quit without updating file.

[cpanelkenneth]

Linux and updated now, but not starting mysql.

Installing /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.so
Appending installation info to /usr/lib/perl5/5.8.8/i386-linux-thread-multi/perllocal.pod
CAPTTOFU/DBD-mysql-4.011.tar.gz
/usr/bin/make install UNINST=1 -- OK
perlmod--Install done
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
Unable to reset root MySQL password. at /scripts/securemysql line 154.
Install Complete
root@server [/scripts]# mysql -v
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
root@server [/scripts]# /etc/init.d/mysql restart
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL. ERROR! Manager of pid-file quit without updating file.
root@server [/scripts]#
root@server [/scripts]#
root@server [/scripts]# mysql -v
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
root@server [/scripts]# ps -ef | grep -i mysql
root 30900 8195 0 09:06 pts/0 00:00:00 grep -i mysql
root@server [/scripts]# /etc/init.d/mysql restart
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL. ERROR! Manager of pid-file quit without updating file.

At this point I recommend opening a support ticket ASAP with our tech support analysts: https://tickets.cpanel.net/submit/in...eqtype=tickets

A few things to investigate:

1) Is there only one version of MySQL installed? On the command line, execute 'rpm -qa | grep -i mysql' It should give output like:

root@pxe [~/traces]# rpm -qa | grep -i mysql
MySQL-devel-5.0.77-0.glibc23
MySQL-shared-5.0.77-0.glibc23
MySQL-client-5.0.77-0.glibc23
MySQL-server-5.0.77-0.glibc23
MySQL-bench-5.0.77-0.glibc23

If there are multiple versions of any of the RPMs, remove the non 5.0.77 version.

2) Make a copy of /etc/my.cnf and /root/.my.cnf, move them out of the way, then attempt restarting MySQL

# mv /etc/my.cnf /etc/my.cnf.backup
# mv /root/.my.cnf /root/.my.cnf.backup
# /scripts/restartsrv_mysql

[shann]

Kenneth, thanks a lot. I didn't find any other version, but getting this message when I start

/scripts/restartsrv_mysql

Failed to locate MySQL socket. Please check the mysql configuration

[cpanelkenneth]

Please open a support request at https://tickets.cpanel.net/submit/in...eqtype=tickets

[shann]

Thank you. Also, /var/lib/mysql/mysql.sock- file is missing. Would it causing the problem?

[sunyl]

Hi Kenneth..

whats the solution for this problem.

-root# rpm -qa | grep -i mysql
MySQL-server-5.0.81-0.glibc23
MySQL-devel-5.0.81-0.glibc23
MySQL-bench-5.0.81-0.glibc23
MySQL-client-5.0.81-0.glibc23
MySQL-shared-5.0.81-0.glibc23
-root#
-root# service mysql stop
ERROR! MySQL manager or server PID file could not be found!
-root# service mysql start
Starting MySQL. ERROR! Manager of pid-file quit without updating file.
-root# /scripts/restartsrv_mysql
Failed to locate MySQL socket. Please check the mysql configuration.
-root#

[cpanelkenneth]

Hi Kenneth..

whats the solution for this problem.

-root# rpm -qa | grep -i mysql
MySQL-server-5.0.81-0.glibc23
MySQL-devel-5.0.81-0.glibc23
MySQL-bench-5.0.81-0.glibc23
MySQL-client-5.0.81-0.glibc23
MySQL-shared-5.0.81-0.glibc23
-root#
-root# service mysql stop
ERROR! MySQL manager or server PID file could not be found!
-root# service mysql start
Starting MySQL. ERROR! Manager of pid-file quit without updating file.
-root# /scripts/restartsrv_mysql
Failed to locate MySQL socket. Please check the mysql configuration.
-root#

try some of the suggestions I offered earlier. If they don't work please open a support ticket at https://tickets.cpanel.net/submit/