Upgrading MySQL to 4.0.x for SME Server


MySQL

SME Versions Supported: v5.x v6 - - Contribs.org certified on: v

Nav Bar Documentation How-to Classification MySQL Upgrading MySQL to 4.0.x for SME Server
Comments Please add your comments about this How To

Author(s): john, haj
Contributor(s): chrsim
License: GPL

Created: 24 Sep 2003 Last updated: 23 Feb 2004

This wiki page has been prepared by Contribs Doc Team


About this How To

Summary: Upgrading MySQL to 4.0.x for SME Server

Keywords: MySQL

Tips: Copied From: http://forums.contribs.org/viewtopic.php?t=18597

Known Limitations and Caveats:

Downloads:


How To

UPDATING TO MYSQL 4.0

1. STOP MYSQL

/etc/rc.d/init.d/mysql stop

2. REMOVE OLD RPM

rpm -e --nodeps mysql-client mysql-server
rpm -e mysql-devel
rpm -e mysqlclient9

3. DOWNLOAD MySQL 4.0. FROM WWW.MYSQL.COM
http://www.mysql.com/downloads/mysql-4.0.html
in a fresh directory
Note: this shows 4.0.15 but replace this with the actual version downloaded.
INSTALL NEW RPMS:

rpm -Uhv MySQL-shared-compat-4.0.15-0.i386.rpm
rpm -Uhv MySQL-server-4.0.15-0.i386.rpm
rpm -Uhv MySQL-client-4.0.15-0.i386.rpm
rpm -Uvh MySQL-devel-4.0.15-0.i386.rpm

4. CONFIGURE

chkconfig --levels 2345 mysql on
rm /etc/rc.d/rc7.d/S90mysqld

mv /etc/rc.d/init.d/mysql /etc/rc.d/init.d/mysqld
ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc7.d/S90mysqld

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no (enable remote access)
/sbin/e-smith/expand-template /root/.my.cnf
ln -s /usr/sbin/mysqld /usr/libexec/ (for conf-mysql-password script)

service mysqld restart

OPTIONAL: INNODB SUPPORT (information from Haj)

mkdir /etc/e-smith/templates-custom/etc/my.cnf
cp /etc/e-smith/templates/etc/my.cnf/009innodb /etc/e-smith/templates-custom/etc/my.cnf
pico /etc/e-smith/templates-custom/etc/my.cnf/009innodb

And comment the only line it contains so the file should look like this:

#skip-innodb

Save the file then do:

/sbin/e-smith/expand-template /etc/my.cnf
service mysqld restart



Nav Bar Documentation How-to Classification MySQL Upgrading MySQL to 4.0.x for SME Server
Comments Please add your comments about this How To

Feedback

Upgrading MySQL to 4.0.x for SME Server Feedback Add your comments to this page.




Wiki Links List

One page links to Upgrading MySQL to 4.0.x for SME Server:
 . Page Name .   . Hits . 
 Upgrading MySQL to 4.0.x for SME Server Feedback   893