How to upgrade mysql from cpanel/whm or from shell. I am currently have 5.0 want to upgrade to latest version.
login via ssh issue the following: mkdir MYSQLBAK cp -pr /var/lib/mysql/ Code (markup): then find /var/cpanel/cpanel.conf or config (forget off the top of my head) find mysql and change to 5.0 (you may want to mv my.cnf to my.cnf.bak while doing this... then just do a /scripts/upcp --force You will need to rebuild php and apache afterward. There may be other ways to do this, but I feel that this, while being more work, is the most stable way to do so. I've done it somewhere in the realm of 75-100 times. Let me know if you run into any problems.
but I already have 5.0 , I want to upgrade to later than 5.0 , is that 5.1.4 current ? I read that if you changing from 5.0 in cpanel to some higher version - you could get crash of system because cpanel doesnt support higher than 5.0 so I want to make it safe
cpanel does support higher than 5.0, just put in 5.1 and run the upcp --force instead of 5.0. be sure to backup dbs and move the my.cnf. If you want help, pm me.
I think MySQL 5.1 is not officially supported by cPanel/WHM but many people have upgraded to MySQL 5.1 without any issue. You can refer following thread for more information: http://forums.cpanel.net/f7/upgraded-mysql-v5-1-30-a-100741.html Kailash