<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="home" title="HomePage" href="HomePage.html" />
<link rel="help" title="HowToUseWiki" href="HowToUseWiki.html" />
<link rel="copyright" title="GNU General Public License" href="http://www.gnu.org/copyleft/gpl.html#SEC1" />
<link rel="author" title="The PhpWiki Programming Team" href="http://phpwiki.org/ThePhpWikiProgrammingTeam" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="Content-Language" content="en" />
<meta name="robots" content="noindex,nofollow" />
<meta name="language" content="en" />
<meta name="document-type" content="Public" />
<meta name="document-rating" content="General" />
<meta name="generator" content="PhpWiki" />
<meta name="PHPWIKI_VERSION" content="1.3.14" />

<link rel="stylesheet" type="text/css" charset="iso-8859-1" href="phpwiki-printer.css" />
<title>PhpWiki - Upgrading MySQL to 4.0.x for SME Server</title>
</head>
<body>

<div id="header">
  
<!-- Page title -->
<h1>Upgrading MySQL to 4.0.x for SME Server</h1>
</div>
<div id="content">



<div class="wikitext"><h2>Upgrading MySQL to 4.0.x for SME Server</h2>
<div class="plugin tightenable" id="CommentPlugin516"></div>
<hr />
<h3>MySQL</h3>
<p class="tightenable top bottom">SME Versions Supported:<b> v5.x v6 </b> - - Contribs.org <a href="Certification%20Process.html" class="named-wiki" title="Certification Process">certified</a> on:<b> v </b></p>
<table class="wiki-dl-table" border="1" cellspacing="0" cellpadding="6"><tr class="tightenable top bottom"><th><i>Nav Bar</i></th>
<th><a href="Documentation.html" class="wiki">Documentation</a></th>
<th><a href="How-to%20Classification.html" class="wiki">How-to Classification</a></th>
<th><a href="MySQL.html" class="wiki">MySQL</a></th>
<td>Upgrading MySQL to 4.0.x for SME Server</td>
</tr>
<tr class="tightenable top"><th><i>Comments</i></th>
<td colspan="4"><a href="Upgrading%20MySQL%20to%204.0.x%20for%20SME%20Server%20Feedback.html" class="named-wiki" title="Upgrading MySQL to 4.0.x for SME Server Feedback">Please add your comments about this How To</a> <br /></td>
</tr>
</table>
<p class="tightenable">Author(s):   <b> john, haj </b> <br />
Contributor(s):   <b> chrsim</b> <br />
License: <b>GPL</b> <br /></p>
<table class="wiki-dl-table" border="1" cellspacing="0" cellpadding="6"><tr class="tightenable bottom"><th>Created:</th>
<th><i>24 Sep 2003</i></th>
<th>Last updated:</th>
<td>23 Feb 2004</td>
</tr>
</table>
<p class="tightenable top bottom"><i>This wiki page has been prepared by Contribs Doc Team</i></p>
<hr />
<h3>About this How To</h3>
<p class="tightenable top"><b>Summary:</b> Upgrading MySQL to 4.0.x for SME Server <br /></p>
<p class="tightenable"><b>Keywords:</b> MySQL <br /></p>
<p class="tightenable bottom"><b>Tips:</b> Copied From: <a href="http://forums.contribs.org/viewtopic.php?t=18597" target="" class="namedurl"><span style="white-space: nowrap"><img src="images/http.png" alt="" class="linkicon" border="0" />http://forums.contribs.org/viewtopic.php?t=18597</span></a> <br /></p>
<blockquote class="tightenable top"><ul><li class="tightenable top bottom">See also <a href="http://forums.contribs.org/viewtopic.php?t=7965" target="" class="namedurl"><span style="white-space: nowrap"><img src="images/http.png" alt="" class="linkicon" border="0" />http://forums.contribs.org/viewtopic.php?t=7965</span></a> <br /></li>
<li class="tightenable top bottom">See also <a href="http://no.longer.valid/modules/mylinks/singlelink.php?cid=208&amp;lid=355" target="" class="namedurl"><span style="white-space: nowrap"><img src="images/http.png" alt="" class="linkicon" border="0" />http://no.longer.valid/modules/mylinks/singlelink.php?cid=208&amp;lid=355</span></a></li>
</ul>
</blockquote>
<p class="tightenable"><b>Known Limitations and Caveats:</b> <br /></p>
<p class="tightenable bottom"><b>Downloads:</b> <br /></p>
<hr />
<h3>How To</h3>
<pre class="tightenable">
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
</pre>
<p class="tightenable bottom"><br /> <br /></p>
<table class="wiki-dl-table" border="1" cellspacing="0" cellpadding="6"><tr class="tightenable top bottom"><th><i>Nav Bar</i></th>
<th><a href="Documentation.html" class="wiki">Documentation</a></th>
<th><a href="How-to%20Classification.html" class="wiki">How-to Classification</a></th>
<th><a href="MySQL.html" class="wiki">MySQL</a></th>
<td>Upgrading MySQL to 4.0.x for SME Server</td>
</tr>
<tr class="tightenable top bottom"><th><i>Comments</i></th>
<td colspan="4"><a href="Upgrading%20MySQL%20to%204.0.x%20for%20SME%20Server%20Feedback.html" class="named-wiki" title="Upgrading MySQL to 4.0.x for SME Server Feedback">Please add your comments about this How To</a></td>
</tr>
</table>
<hr />
<h3>Feedback</h3>
<p class="tightenable top bottom"><a href="Upgrading%20MySQL%20to%204.0.x%20for%20SME%20Server%20Feedback.html" class="wiki">Upgrading MySQL to 4.0.x for SME Server Feedback</a> Add your comments to this page.
<br /> <br /></p>
<span class="plugin" id="CommentPlugin517"></span><p class="tightenable top bottom"><br /> <br /></p>
<hr />
<h3>Wiki Links List</h3>
<span class="plugin" id="BackLinksPlugin270"><table cellpadding="0" cellspacing="1" border="0" class="pagelist" width="100%" summary="Columns: Page Name, Hits.">
<caption align="top">
One page links to <a href="Upgrading%20MySQL%20to%204.0.x%20for%20SME%20Server.html" class="wiki">Upgrading MySQL to 4.0.x for SME Server</a>:</caption>
<colgroup span="2"></colgroup>
<thead>
<tr>
<th align="center" valign="middle" class="gridbutton"><a href="Upgrading%20MySQL%20to%204.0.x%20for%20SME%20Server.html?directory=%2Ftmp%2Fwikidumphtml&amp;sortby=%2Bpagename&amp;id=311" class="gridbutton" title="Click to sort by pagename">&nbsp;<img src="images/buttons/no_order.png" width="7" height="7" border="0" alt="." />&nbsp;Page Name&nbsp;<img src="images/buttons/no_order.png" width="7" height="7" border="0" alt="." />&nbsp;</a></th>
<th align="center" valign="middle" class="gridbutton"><a href="Upgrading%20MySQL%20to%204.0.x%20for%20SME%20Server.html?directory=%2Ftmp%2Fwikidumphtml&amp;sortby=-hits&amp;id=311" class="gridbutton" title="Click to sort by hits">&nbsp;<img src="images/buttons/no_order.png" width="7" height="7" border="0" alt="." />&nbsp;Hits&nbsp;<img src="images/buttons/no_order.png" width="7" height="7" border="0" alt="." />&nbsp;</a></th>
</tr>
</thead>
<tbody>
<tr class="evenrow">
<td>&nbsp;<a href="Upgrading%20MySQL%20to%204.0.x%20for%20SME%20Server%20Feedback.html" class="wiki">Upgrading MySQL to 4.0.x for SME Server Feedback</a>&nbsp;</td>
<td align="right">&nbsp;893&nbsp;</td>
</tr>
</tbody>
</table>
</span></div>

<div id="footer">  <hr class="printer" noshade="noshade" />
<p class="editdate">Owner: &quot;wellsi&quot;  Last edited on March 23, 2004  2:17 am by &quot;wellsi&quot;</p>
</div>

</div>
<!-- Add your Disclaimer here -->
</body>
</html>
