MySQL Upgrade

2

August 14, 2012 by harshalvaidya

MySQL Upgrade

First, check the current versions of MySQL, PHP, and Apache:

root@localhost ~ # mysql -V

root@localhost ~ # /usr/local/apache/bin/httpd -v

root@localhost ~ # php -v

root@localhost ~ # /usr/local/cpanel/bin/rebuild_phpconf –current
Let’s go ahead and check all of the databases, and note if there are any databases with errors:

for i in `mysql -BN -e “show databases”`; do mysqlcheck $i | grep -v OK; done;

After checking the databases, go ahead and run a repair:

for i in `mysql -BN -e “show databases”`; do mysqlcheck -r $i | grep -v OK; done;

Then check once more. Note any databases with errors or corruption:

for i in `mysql -BN -e “show databases”`; do mysqlcheck $i | grep -v OK; done;

Let’s go ahead and backup all of the databases:

root@localhost ~ # mkdir /home/upgrade_temp
root@localhost ~ # cd /home/upgrade_temp
root@localhost /home/upgrade_temp# for i in `mysql -BN -e “show databases”`; 

do mysqldump $i > $i.sql; cp -pvR /var/lib/mysql/$i /home/upgrade_temp/; done;

Check to make sure the databases are dumped and copied:

root@localhost /home/upgrade_temp # ll
total 964
-rw-r–r– 1 root root 4749 Dec 19 19:42 cphulkd.sql
-rw-r–r– 1 root root 783 Dec 19 19:42 Database.sql
-rw-r–r– 1 root root 34565 Dec 19 19:42 eximstats.sql
-rw-r–r– 1 root root 181121 Dec 19 19:42 horde.sql
-rw-r–r– 1 root root 1264 Dec 19 19:42 information_schema.sql
-rw-r–r– 1 root root 1902 Dec 19 19:42 leechprotect.sql
-rw-r–r– 1 root root 2911 Dec 19 19:42 modsec.sql
-rw-r–r– 1 root root 424398 Dec 19 19:42 mysql.sql
-rw-r–r– 1 root root 299110 Dec 19 19:42 roundcube.sql

Check/Remove the MySQL upgrade lock that might be in place, this might not exist currently:

root@localhost /home/upgrade_temp # rm -v /etc/mysqlupdisable

root@localhost /home/upgrade_temp # rm -v /etc/mysqldisable

Now, let’s upgrade MySQL.
Run /scripts/upcp first.

You will first need to specify which version of MySQL you are going to use by editing: /var/cpanel/cpanel.config

Look for this line:

mysql-version=x.x

You would change to to x.x,x.x or x.x, depending on which version you want. For this upgrade, we are using:

mysql-version=x.x

Save the file and run the upgrade:

root@localhost /home/upgrade_temp # /scripts/mysqlup –force

MySQL Setup Script Version 7.0
Loaded cPPkgs::MySQL ok!
This is the cPPkgs::MySQL x.x.x installer for Linux.
Fetching …………………….
Preparing……………………….–Install done
…………………..
……………………..
………………………
Install Complete.

Let’s make sure MySQL is running:

root@localhost ~ # mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Server version: 5.1.30 MySQL Community Server (GPL)

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> status

mysql> quit
Bye
If you upgraded from MySQL x.x and MySQL fails to start:

root@localhost /home/upgrade_temp # /etc/init.d/mysql start
MySQL manager or server PID file could not be found! [FAILED]
Starting MySQLCouldn’t find MySQL manager or server [FAILED]

Make sure to remove or comment the following line from /etc/my.cnf:

# Basedir=/var/lib/mysql
Once this is completed you need check all of the databases for errors:

root@localhost /home/upgrade_temp # mysql_upgrade

This will check and update all sql databases. If the check fails, it will be repaired automatically at the end of the script.

Now that MySQL was upgrade you will need to recompile Apache/PHP to support the new MySQL version:

root@localhost ~ # /scripts/easyapache

Make sure to check under PHP4/PHP5 that MySQL of the system support is enabled.

Once the recompile is completed, check the versions:

root@localhost ~ # mysql -V

root@localhost ~ # /usr/local/apache/bin/httpd -v

root@localhost ~ # php -v

root@localhost ~ # /usr/local/cpanel/bin/rebuild_phpconf –current

Now, there is one last task: Rebuilding cPanel’s PHP interpreter to take advantage of the new libraries:

/scripts/makecpphp

This will take a while. Once it’s finished, verify that PHPMyAdmin? loads. And all is set 😉