Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2006
    Posts
    90

    How Do I Move MySQL From 4.0 to 4.1 with RPMS?

    I'm not sure I really understand the ins and outs of upgrading MySQL and I'm afraid to mess it up. From the MySQL site I see there's a 4.1.22 RPM available (http://dev.mysql.com/downloads/mysql/4.1.html) and I'm running 4.0.18 (Your MySQL connection id is 2763253 to server version: 4.0.18-Max-log)

    I'm not sure I want to bump it up all the way to 5, but I would like to run 4.1, but I also would like to stick with the RPMS, even after reading whatever I can find, I'm still not sure I understand what RPMs to install, here's what I have currently.

    Code:
    >> rpm -qa | grep -i mysql
    php-mysql-4.3.11-1.1.rhel3.ct
    MySQL-shared-compat-4.0.18-0
    MySQL-Max-4.0.18-0
    libdbi-dbd-mysql-0.6.5-5
    MySQL-server-4.0.18-0
    perl-DBD-MySQL-2.1021-4.EL3
    MySQL-python-0.9.1-6
    MySQL-client-4.0.18-0
    MySQL-devel-4.0.18-0
    There doesn't seem to be anything newer on the up2date server I use:

    Code:
    >>up2date --showall | grep -i mysql
    MySQL-python-0.9.1-6.i386
    libdbi-dbd-mysql-0.6.5-5.i386
    mod_auth_mysql-20030510-2.ent.i386
    mysql-3.23.58-16.RHEL3.1.i386
    mysql-bench-3.23.58-16.RHEL3.1.i386
    mysql-devel-3.23.58-16.RHEL3.1.i386
    mysql-server-3.23.58-16.RHEL3.1.i386
    perl-DBD-MySQL-2.1021-4.EL3.i386
    php-mysql-4.3.2-39.ent.i386
    qt-MySQL-3.1.2-14.RHEL3.i386
    Can anyone give me any pointers?

  2. #2
    Join Date
    May 2006
    Location
    India
    Posts
    661
    Hello,

    To upgrade to 4.1, you have to download the following new rpm mysql packages and install it.

    MySQL-shared-compat
    MySQL-Max
    MySQL-server
    MySQL-client
    MySQL-devel


    Download all these packages into a folder say "/root/downloads" and use rpm -Uvh *.rpm to install it

    cd /root/downlods
    rpm -Uvh *.rpm
    SparkSupport.Com - The Premier Tech Company
    Cloud Solutions|Email Infra setup|VOIP|Video Streaming|Software Development
    Email: info@sparksupport.com Phone : 1- 408-600-1449 | Skype : shijils

  3. #3
    Join Date
    Jun 2006
    Posts
    90
    Thanks Spark.

    No need to worry about any troubles with Apache or PHP?

  4. #4
    you may need to upgrade or recompile your PHP / Apache to work with the new MySQL version
    Tweakservers : Authorised Reseller of SmarterMail | SmarterStats | SmarterStats | Mailenable

  5. #5
    Join Date
    Apr 2004
    Location
    Singapore
    Posts
    1,522
    and one golden rule during upgrade, BACKUP your sql data
    tanfwc

  6. #6
    Join Date
    Aug 2003
    Location
    Florida
    Posts
    181
    Those RPMs should take care of it, but MAKE SURE to back up your data. Also look into the old-passwords variable for your mysql config. There are some changes in the way MySQL manages password hashes in 4.1 from 4.0
    Tyler
    www.AdminZoom.com
    "Server Administration Done Right"

    Server setup, hardening, migrations and more

Posting Permissions

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