The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

upgrading MySQL to 4.1.X

Discussion in 'General Discussion' started by yousef, May 15, 2005.

  1. yousef

    yousef Member

    Joined:
    Jul 20, 2004
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  2. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    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.
     
  3. yousef

    yousef Member

    Joined:
    Jul 20, 2004
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    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?.


    =========
    PHP:
    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
     
Loading...

Share This Page