Re: Upgrading MySQL on RedHat 9

2003-07-03 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi,

On Wed, 2 Jul 2003, Paul DuBois wrote:

 At 11:33 -0400 7/2/03, Andrew Pierce wrote:

 I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to
 go from the version that came with the distro (version 3.23.54) to the
 latest (verion 4.0).
 
 Just thought I'd post to get a heads-up on any known issues or
 prerequisites. I just hate it when I try something like this and screw up
 my whole installation.
 
 My planned steps are to:
 
 1. mysqldump everything to a backup file
 2. stop the service
 3. uninstall all the current rpm's
 4. install the fresh rpm's
 5. startup
 6. \. the file from step 1
 
 Anything I need to lookout for?

If you want to keep apps that shipped with the distro but are linked
against the 3.23 libmysqlclient, you may want to install
MySQL-shared-compat to satisfy the RPM library dependencies.

 That should work, but after you install the new RPM files, use

 chkconfig --list mysql

 to make sure that the server is set to start on runlevels 2 through 5.
 If it's not, use:

 chkconfig --levels 2345 mysql on

 Otherwise, the server won't start automatically at system boot time.

 This problem has been seen on RH 8 and RH 9. I understand it's been
 fixed now, but I'm not sure if the fix is in the current release or
 the next one.

It will be fixed for 4.0.14:

http://bugs.mysql.com/bug.php?id=272

Bye,
LenZ
- -- 
 Lenz Grimmer [EMAIL PROTECTED]
 Senior Production Engineer
 MySQL GmbH, http://www.mysql.de/
 Hamburg, Germany

 For technical support contracts, visit https://order.mysql.com/?ref=mlgr
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux)
Comment: For info see http://quantumlab.net/pine_privacy_guard/

iD8DBQE/BIQsSVDhKrJykfIRAsaIAJ0RkCCcoWOTJ1gHCkZ+MSvvt3vxBACfeW7X
P7xkEZ1GfESz7bwMpF4+5/E=
=aHHD
-END PGP SIGNATURE-

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Upgrading MySQL on RedHat 9

2003-07-02 Thread Andrew Pierce
I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to
go from the version that came with the distro (version 3.23.54) to the
latest (verion 4.0).

Just thought I'd post to get a heads-up on any known issues or
prerequisites. I just hate it when I try something like this and screw up
my whole installation.

My planned steps are to:

1. mysqldump everything to a backup file
2. stop the service
3. uninstall all the current rpm's
4. install the fresh rpm's
5. startup
6. \. the file from step 1

Anything I need to lookout for?

Thanks.
Andrew



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Upgrading MySQL on RedHat 9

2003-07-02 Thread Paul DuBois
At 11:33 -0400 7/2/03, Andrew Pierce wrote:
I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to
go from the version that came with the distro (version 3.23.54) to the
latest (verion 4.0).
Just thought I'd post to get a heads-up on any known issues or
prerequisites. I just hate it when I try something like this and screw up
my whole installation.
My planned steps are to:

1. mysqldump everything to a backup file
2. stop the service
3. uninstall all the current rpm's
4. install the fresh rpm's
5. startup
6. \. the file from step 1
Anything I need to lookout for?
That should work, but after you install the new RPM files, use

chkconfig --list mysql

to make sure that the server is set to start on runlevels 2 through 5.
If it's not, use:
chkconfig --levels 2345 mysql on

Otherwise, the server won't start automatically at system boot time.

This problem has been seen on RH 8 and RH 9. I understand it's been
fixed now, but I'm not sure if the fix is in the current release or
the next one.
Thanks.
Andrew


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]