rm /var/cpanel/mysqlup
That will stop upcp from touching MySQL.
To upgrade manually
If you upgrade manually you need to remember to create the file:
#touch /etc/mysqlupdisable
(Otherwise upcp will simply downgrade it again.)
service mysql stop
service chkservd stop
Grab the official RPMs
rpm -Uvh MySQL-*.rpm
service chkservd start
You should recompile PHP after a MySQL upgrade to make sure any MySQL library/client changes go into effect.
####################################################################
AUTOMATED whm/cpanel way for CentOS...
source:http://forums.cpanel.net/showpost.php?p=184462&postcount=15
ok... figured it out...
basically... this is for CentOS... update your yum.conf to one with working mirrors... then you have to delete /root/.cpmysqlrpm/mirrors.failed (i forgot the exact name)... then re-run /scripts/mysqlup
go here and follow instructions on getting the latest yum.conf (wget it, don't copy and paste, you'll get errors)
http://www.versaweb.net/forums/show...p?p=484#post484
ok.. so here the steps:
1. update yum.conf
Code:
cd /etc
mv yum.conf yum.conf.original
wget http://www.versaweb.net/scripts/general/yum.conf
chmod 644 yum.conf
rpm --import http://mirrors.versaweb.net/cAos/centos/RPM-GPG-KEY-CentOS-3
2. remove failed mirrors list (it's probably spelled differently)
Code:
rm -rf /root/.cpmysqlrpm/mirrors.failed
rm -rf /root/.cpmysqlrpm/pingtimes/*
3. add these mirrors to mirrors.lst (i got em from a RHE3 server)
Code:
vi /root/.cpmysqlrpm/mirrors.lst
http://www.maxmind.com/geoip/
http://mysql.he.net/
http://mysql.247available.com/
http://mysql.mirrors.pair.com/
http://mysql.mirror.redwire.net/
http://mysql.fasterline.net/
http://mirror.aphix.com/mysql/
http://mysql.takiweb.com/
http://www.unixsoft.org/mysql/
http://mirrors.develooper.com/mysql/
http://mysql.orst.edu/
http://mysql.zawodny.com/
http://mysql.mirrors.hoobly.com/
http://mirror.services.wisc.edu/mysql/
http://mysql.binarycompass.org/
http://gd.tuwien.ac.at/db/mysql/
http://mysql.belnet.be/
http://mysql.easynet.be/
http://mysql.skynet.be/
http://mysql.scarlet.be/
http://mysql.urc.bl.ac.yu/
http://mysql.blic.net/
http://mysql.online.bg/
http://mysql.linux.cz/
http://mysql.ftp.cvut.cz/
http://mirrors.sunsite.dk/mysql/
http://mysql.mirrors.cybercity.dk/
http://mysql.mirror.ok.ee/
http://mysql.tonnikala.org/
http://mysql.netello.fi/
http://mir2.ovh.net/ftp.mysql.com/
http://mysql.crihan.fr/
http://www.fh-wolfenbuettel.de/ftp/pub/database/mysql/
http://sunsite.informatik.rwth-aachen.de/mysql/
http://ftp.gwdg.de/pub/misc/mysql/
http://mirrors.ntua.gr/MySQL/
http://www.ntua.gr/mysql/
http://mirrors.ee.teiath.gr/mysql/
http://mysql.sote.hu/
http://mysql.rhnet.is/
http://ftp.heanet.ie/mirrors/www.mysql.com/
http://www.teta.it/mysql/
http://mysql.mirror.widexs.nl/
http://mysql.proserve.nl/
http://gnu.kookel.org/ftp/mysql/
http://mysql.mirror.trueserver.nl/
http://mysql.mirror.rokscom.nl/
http://ftp.snt.utwente.nl/pub/software/mysql/
http://sunsite.icm.edu.pl/mysql/
http://mysql.mainseek.com/
http://ftp.tpnet.pl/vol/d3/ftp.mysql.com/
http://darkstar.ist.utl.pt/mysql/
http://mysql.telepac.pt/
http://mirror.freedevices.org/mysql/
http://carti.cs.unibuc.ro/mysql/
http://mysql.directnet.ru/
http://mysql.tsuren.net/
http://mysql.l.rt-comm.ru/
http://ftp.arnes.si/mysql/
http://www.fastmirrors.org/mysql/
http://mysql.interec.es/
http://ftp.sunet.se/pub/unix/databases/relational/mysql/
http://mysql.dataphone.se/
http://sunsite.cnlab-switch.ch/ftp/mirror/mysql/
http://www.oynasana.com/mysql/
http://mysql.dp.ua/
http://mysql.paco.net/
http://mysql.ensita.net/
http://mysql.mirror.anlx.net/
http://mysql.mirrored.ca/
http://mysql.mirror.secondchapter.info/
http://mysql.mirror.cygnal.ca/
http://mirror.cpsc.ucalgary.ca/mirror/mysql.com/
http://mysql.serenitynet.com/
http://mysql.azc.uam.mx/
http://mirrors.hpcf.upr.edu/mysql/
http://mirror.aphix.com/mysql/
http://mysql.he.net/
http://mirror.services.wisc.edu/mysql/
http://mysql.orst.edu/
http://mysql.mirrors.pair.com/
http://mysql.zawodny.com/
http://mysql.fasterline.net/
http://www.unixsoft.org/mysql/
http://mysql.takiweb.com/
http://mirrors.develooper.com/mysql/
http://mysql.mirror.redwire.net/
http://mysql.binarycompass.org/
http://mysql.mirrors.hoobly.com/
http://mysql.247available.com/
http://mysql.bannerlandia.com.ar/
http://mysql.datahost.com.ar/
http://mysql.xmundo.net/
http://mysql.mesi.com.ar/
http://mysql.megalink.com/
http://www.linorg.usp.br/mysql/
http://mysql.vision.cl/
http://mysql.tecnoera.com/
http://mysql.linuxforum.net/
http://mysql.ihostunit.com/
http://mysql.cbn.net.id/
http://mysql.fresh.co.il/
http://www.softagency.co.jp/MySQL/
http://mirrors.mybsd.org.my/mysql/
http://mirrors.webcraftsolutions.com/mysql/
http://www.opensourcecommunity.ph/mysql/
http://mysql.oss.eznetsols.org/
http://mysql.byungsoo.net/
http://mysql.holywar.net/
http://mysql.new21.com/
http://mysql.cdpa.nsysu.edu.tw/
http://mysql.nctu.edu.tw/
http://mysql.isu.edu.tw/
http://mysql.uahrc.se.ntou.edu.tw/
http://ftp.tku.edu.tw/mysql/
http://mysql.mirrors.isp-thailand.com/
http://mysql.mirrors.ilisys.com.au/
http://mysql.ausgamers.com/
http://kiwinz.kiwiplan.co.nz/mysql/
http://mysql.inspire.net.nz/
4. in WHM.... Server Setup --> Update Config
select "Manual Updates Only (bleeding EDGE tree)"
**this is CURRENTLY only necessary for the WHM 10.1.0 cPanel 10.2.0-S83 running on CentOS, because anything other than that will only allow you to update to an OLDER mysql 4.1.10a **
NOTE: you set this ONLY to run /scripts/mysqlup then you set it back to normal after it's done... (STABLE is what we use)
5.
Code:
/scripts/mysqlup
6. when done... go back to WHM and set "Server Setup --> Update Config" back to your normal settings
and, that should do it....