Results 1 to 6 of 6
-
04-04-2007, 09:02 PM #1Junior Guru Wannabe
- 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
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
-
04-05-2007, 04:15 AM #2Web Hosting Master
- 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
-
04-05-2007, 09:25 AM #3Junior Guru Wannabe
- Join Date
- Jun 2006
- Posts
- 90
Thanks Spark.
No need to worry about any troubles with Apache or PHP?
-
04-05-2007, 10:43 AM #4Aspiring Evangelist
- Join Date
- Mar 2006
- Posts
- 427
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
-
04-05-2007, 11:06 AM #5Web Hosting Master
- Join Date
- Apr 2004
- Location
- Singapore
- Posts
- 1,522
and one golden rule during upgrade, BACKUP your sql data
tanfwc
-
04-05-2007, 11:10 AM #6Junior Guru
- 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