"Upgrading" MySQL

Discussion in 'Server Operation' started by dunnma, Sep 9, 2007.

  1. dunnma

    dunnma New Member

    I just recently setup a VPS III server with 1and1.com. Below are the server particulars:

    OS: fedora-core-4-x86_64
    Packages:
    devel-fc4-x86_64 / 20060804
    fc4-x86_64-custom-config / 20061205
    fc4-x86_64-psa8-key / 20061205
    fc4-x86_64-psa8-language / 20061205
    mod_perl-fc4-x86_64 / 20060411
    mod_ssl-fc4-x86_64 / 20060804
    mysql-fc4-x86_64 / 20060804
    php-fc4-x86_64 / 20060220
    psa-bu-fc4-x86_64 / 20060614
    psa-fc4-x86_64 / 20060614
    psa-vault-fc4-x86_64 / 20060611

    I have everything up and running and I just noticed that the version of MySQL is 4.1.20. I want to upgrade to 5.0.45 (latest stable). The problem is I have no clue how to begin. I have spent hours and hours looking and trying things, but nothing is working. There is no data that I need to keep, basically start from scratch.

    The current "installation" is located in the /var/lib/mysql directory.

    Does anyone have "simple" instructions on how to upgrade, or install the latest version of MySQL? I know enough to be dangerous.

    Thanks in advance!
     
  2. falko

    falko Super Moderator ISPConfig Developer

  3. dunnma

    dunnma New Member

  4. falko

    falko Super Moderator ISPConfig Developer

    Any errors in your logs? Any errors when you restart MySQL? What's the output of
    Code:
    ps aux | grep -i mysql
    and
    Code:
    netstat -tap
    ?
     
  5. dunnma

    dunnma New Member

    Actually I figured out my problem late last night. It is a 64 bit server. Here is the complete upgrade script that worked for me.

    # Install yum
    rpm -ivh http://update.onlinehome-server.com...ra/RPMS/python-elementtree-1.2.6-4.x86_64.rpm http://update.onlinehome-server.com.../Fedora/RPMS/python-sqlite-1.1.6-1.x86_64.rpm http://update.onlinehome-server.com...ora/RPMS/python-urlgrabber-2.9.6-1.noarch.rpm http://update.onlinehome-server.com/fedora/linux/core/4/x86_64/os/Fedora/RPMS/yum-2.3.2-7.noarch.rpm

    # Remove old MySQL
    yum remove mysql

    # CD to tmp
    cd /tmp/

    # Get new MySQL files
    wget http://dev.mysql.com/get/Downloads/....glibc23.x86_64.rpm/from/http://mysql.he.net/
    wget http://dev.mysql.com/get/Downloads/....glibc23.x86_64.rpm/from/http://mysql.he.net/
    wget http://dev.mysql.com/get/Downloads/....glibc23.x86_64.rpm/from/http://mysql.he.net/
    wget http://dev.mysql.com/get/Downloads/....glibc23.x86_64.rpm/from/http://mysql.he.net/
    wget http://dev.mysql.com/get/Downloads/....glibc23.x86_64.rpm/from/http://mysql.he.net/

    # Install new MySQL files
    rpm -U MySQL-server-5.0.45-0.glibc23.x86_64.rpm MySQL-client-5.0.45-0.glibc23.x86_64.rpm MySQL-devel-5.0.45-0.glibc23.x86_64.rpm MySQL-shared-5.0.45-0.glibc23.x86_64.rpm MySQL-shared-compat-5.0.45-0.glibc23.x86_64.rpm

    Thanks for the help! Hopefully this can help someone else.
     

Share This Page