upgrading MySQL to 4.1.X

[yousef]

hi all,

I have to upgrade MySQL from v 3.0.28 to v 4.1.X, I have WHM installed in mysever and i use RH 9 Oprating System.

What is the best way to upgrade?and does the upgrading have any drawback for WHM?

Regards,
Yousef

[webignition]

From WHM > Tweak Settings > MySQL you can set which version of MySQL to use, however the more recent versions of WHM/Cpanel only give the option of MySQL 4 or 4.1.

This makes me wonder what version of WHM/Cpanel you are running if you have MySQL 3.0.28, and you may want to consider upgrading to the latest RELEASE version of WHM/Cpanel before upgrading MySQL.

Before upgrading MySQL make sure you backup all databases - MySQL 4 to 4.1 is not automatically reversible and so I assume that 3.X to 4.1 will be practically impossible to revert from without full database backups.

[yousef]

thanX webignition
after i opened Tweak Settings i choose second option and i clicked Save,after that the system told me ((click here)) after i click i got the result belw,and i find my mysql v is 4.0.28 not 4.1.8,Does the mydql data base from V 4.1.8 work fine on 4.0.28? or i must to upgrade to 4.1.8?.


=========

Ftp Setup Script Version 6.0 Fetching version information from http://updates.cpanel.net/ftpinstall/version (STABLE)....Unable to retrieve file Done This is the proftpd  installer release number  for platform redhat 9 Using RPM Backend: RPM version 4.2 Fetching rpm updates list...Unable to retrieve file cached /root/.cpupdates/5-15-2005.updates is up to date...Unable to retrieve file Done  gzip: /root/.cpupdates/5-15-2005.updates.gz: unexpected end of file Fetching rpm provides list...Unable to retrieve file md5sum: /root/.cpupdates/5-15-2005.provides: No such file or directory  bzip2: Compressed file ends unexpectedly;        perhaps it is corrupted?  *Possible* reason follows. bzip2: Success        Input file = /root/.cpupdates/5-15-2005.provides.bz2, output file = /root/.cpupdates/5-15-2005.provides  It is possible that the compressed file(s) have become corrupted. You can use the -tvv option to test integrity of such files.  You can use the `bzip2recover' program to attempt to recover data from undamaged sections of corrupted files.  bzip2: Deleting output file /root/.cpupdates/5-15-2005.provides, if it exists. Done Cannot fetch rpm provides list at /scripts/cPanelRPM.pm line 221. Resetting proftpd to cPanel Defaults and Installing the Latest Version --16:33:38--  http://diff.cpanel.net/ftpinstall/proftpd/redhat/9/proftpd--.i386.rpm           => `proftpd--.i386.rpm' Resolving diff.cpanel.net... failed: Host not found. Failed to download http://diff.cpanel.net/ftpinstall/proftpd//redhat/9/proftpd--.i386.rpm .. using source instead Using RPM Backend: RPM version 4.2 Fetching rpm updates list...Unable to retrieve file cached /root/.cpupdates/5-15-2005.updates is up to date...Unable to retrieve file Done  gzip: /root/.cpupdates/5-15-2005.updates.gz: unexpected end of file Fetching rpm provides list...Unable to retrieve file md5sum: /root/.cpupdates/5-15-2005.provides: No such file or directory  bzip2: Compressed file ends unexpectedly;        perhaps it is corrupted?  *Possible* reason follows. bzip2: Success        Input file = /root/.cpupdates/5-15-2005.provides.bz2, output file = /root/.cpupdates/5-15-2005.provides  It is possible that the compressed file(s) have become corrupted. You can use the -tvv option to test integrity of such files.  You can use the `bzip2recover' program to attempt to recover data from undamaged sections of corrupted files.  bzip2: Deleting output file /root/.cpupdates/5-15-2005.provides, if it exists. Done Cannot fetch rpm provides list at /scripts/cPanelRPM.pm line 221. --16:36:18--  http://diff.cpanel.net/ftpinstall/proftpd/src/proftpd--.src.rpm           => `proftpd.src.rpm' Resolving diff.cpanel.net... failed: Host not found. Building RPM...Done Failed to download http://diff.cpanel.net/ftpinstall/proftpd/src/proftpd--.src.rpm at /scripts/ftpup line 255. MySQL Setup Script Version 6.0 Fetching version information from http://updates.cpanel.net/mysqlinstall/version (STABLE)....Unable to retrieve file Done This is the MySQL  installer release number  for platform MySQL- is up to date Install Complete Unable to retrieve file Using Mysql4 Using RPM Backend: RPM version 4.2 Fetching rpm updates list...Unable to retrieve file cached /root/.cpupdates/5-15-2005.updates is up to date...Unable to retrieve file Done Fetching rpm provides list...Unable to retrieve file Done  Complete