We do support Round the Clock 24 x 7 x 365 (+91) 883 012 3924
 

How to upgrade mysql with CloudLinux on cPanel server

How to upgrade mysql with CloudLinux on cPanel server

Using the mysql upgrade option in WHM will not work on CloudLinux installed server

Before proceed further we need to take backup of mysql databases in .sql format.

If you want to backup single database, execute below command to dump database contents to text file.

mysqldump sampledb > sampledb.sql

# For all databases on server, execute below command.

mysqldump –all-databases > all_databases.sql

# For upgrading to MySQL 5.5, you should to do:

/usr/share/lve/dbgovernor/db-select-mysql –mysql-version=mysql55
/usr/share/lve/dbgovernor/db-select-mysql –install-now

That’s it

root@L3webhosting.com [~]# mysql -V
mysql Ver 14.14 Distrib 5.5.34, for Linux (x86_64) using readline 5.1
root@L3webhosting.com [~]#

Now you need to recompile apache/php after mysql upgrade.

You can contact us at esupport@L3webhosting.com if you require any further assistance.

Comments are closed.