Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2005
    Posts
    76

    Painless MySQL upgrade?

    What is the best, easiest, painless way of upgrading from one version of MySQL to another?
    Currently I have 5.0.24a and I would like to upgrade to the latest (5.0.5, I think).
    I would rather do it myself than bother my host.


    FYI, if this might help:

    MySQL version:
    mysql Ver 14.12 Distrib 5.0.24a, for redhat-linux-gnu (i686) using readline 5.0
    I am running CentOS 4.4-32.

  2. #2
    1. Login to your server via via SSH

    2. mkdir mysql - create mysql directory (here you will download your mysql installation packages)

    3. cd mysql - enter the mysql directory

    4. download all mysql packages your want to install in this directory

    You can download the lates mysql version from http://dev.mysql.com/downloads/mysql/5.0.html

    If you do not know which packages to download, download these four:

    wget http://dev.mysql.com/get/Downloads/M.../mysql.he.net/

    wget http://dev.mysql.com/get/Downloads/M...ysql.orst.edu/

    wget http://dev.mysql.com/get/Downloads/M...isc.edu/mysql/

    wget http://dev.mysql.com/get/Downloads/M...ysql.orst.edu/

    And after finishing all the downloads it is time to install these packages. Since you are in the directory where all your packages are downloaded, you can do that with the following command:

    rpm -Uvh *

    After that, just restart your mysql service with this command:

    /etc/init.d/mysqld restart

    I hope this helps.
    Last edited by RoseHosting; 05-02-2008 at 06:29 PM.
    ---=== RoseHosting.com Admin ===---
    Linux Cloud Hosting - linuxcloudvps.com
    Linux VPS Hosting - rosehosting.com
    High Quality Linux virtual servers with lots of Guaranteed RAM and HDD space, Impeccable Service.

  3. #3
    Join Date
    Nov 2005
    Posts
    76
    Tried that.. getting this error:

    [[email protected] MySql5.0.51]# rpm -Uvh *
    warning: MySQL-client-community-5.0.51a-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
    Preparing... ########################################### [100%]
    file /usr/lib/libmysqlclient.so from install of MySQL-shared-community-5.0.51a-0.rhel4 conflicts with file from package mysql-compat-5.0.24a-3.rhel4.art
    file /usr/lib/libmysqlclient_r.so from install of MySQL-shared-community-5.0.51a-0.rhel4 conflicts with file from package mysql-compat-5.0.24a-3.rhel4.art

  4. #4
    You will need to uninstall old MySQL rpms from your server. Please use the following command line command:

    rpm -qa | grep 'mysql'

    It will list out all the mysql rpms installed on your server.

    Run 'rpm -e mysqlxxxx' (e.g. rpm -e mysql-compat-5.0.24a-3.rhel4.art) and uninstall all mysql 5.0.24a-3 packages from your server and after that install the new mysql 5.0.51 version:

    - enter the mysql directory and install all previously downloaded mysql 5.0.51 packages using the following command line command:

    rpm -ivh *

    - restart your mysql service using the following command line command:

    /etc/init.d/mysqld restart
    ---=== RoseHosting.com Admin ===---
    Linux Cloud Hosting - linuxcloudvps.com
    Linux VPS Hosting - rosehosting.com
    High Quality Linux virtual servers with lots of Guaranteed RAM and HDD space, Impeccable Service.

  5. #5
    Join Date
    Nov 2005
    Posts
    76
    duh! Now I'm getting this error:

    [[email protected] MySql5.0.51]# rpm -ivh *
    warning: MySQL-client-community-5.0.51a-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
    error: Failed dependencies:
    MySQL conflicts with mysql-5.0.24a-3.rhel4.art.i386
    MySQL-server conflicts with mysql-server-5.0.24a-3.rhel4.art.i386
    And I did uninstall old MySQL rpms! ((

  6. #6
    Join Date
    Nov 2005
    Posts
    76
    Is it because I have Plesk control panel installed?

  7. #7
    Join Date
    Nov 2005
    Posts
    76
    Well, guess I lied! I couldn't quite uninstall old MySQL rpms.

    I was getting

    [[email protected] MySql5.0.51]# rpm -e mysql-server-5.0.24a-3.rhel4.art
    error: Failed dependencies:
    mysql-server >= 4.1.11 is needed by (installed) psa-predb-8.1.0-rhel4.build81061213.17.noarch
    mysql-server is needed by (installed) psa-qmail-rblsmtpd-0.70-rhel4.build81061129.22.i586
    mysql-server is needed by (installed) sitebuilder-core-3.0-rhas4.build06112310.i386
    mysql-server >= 4.1.11 is needed by (installed) psa-8.1.1-cos4.build81070322.16.i586
    but failed to notice that untill now..

  8. #8
    Probably you deleted your mysql-compat package only.

    Please uninstall all mysql packages listed with the "rpm -qa | grep 'mysql'" command line command :

    rpm -e mysql-5.0.24a-3.rhel4.art.i386

    rpm -e mysql-server-5.0.24a-3.rhel4.art.i386

    and all other mysql packages listed with the "rpm -qa | grep 'mysql'" command line command.

    I hope this helps.
    ---=== RoseHosting.com Admin ===---
    Linux Cloud Hosting - linuxcloudvps.com
    Linux VPS Hosting - rosehosting.com
    High Quality Linux virtual servers with lots of Guaranteed RAM and HDD space, Impeccable Service.

  9. #9
    Quote Originally Posted by albano View Post
    Is it because I have Plesk control panel installed?
    Since you are using Plesk, install your mysql-compat package using:

    yum install mysql-compat

    and try to update your MySQL using the following command line command:

    yum update mysql
    ---=== RoseHosting.com Admin ===---
    Linux Cloud Hosting - linuxcloudvps.com
    Linux VPS Hosting - rosehosting.com
    High Quality Linux virtual servers with lots of Guaranteed RAM and HDD space, Impeccable Service.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •