https://wiki.atomicorp.com/wiki/index.php?title=Mysql&feed=atom&action=historyMysql - Revision history2024-03-29T06:45:01ZRevision history for this page on the wikiMediaWiki 1.20.2https://wiki.atomicorp.com/wiki/index.php?title=Mysql&diff=3452&oldid=prevMshinn: /* Installation */2013-05-11T20:08:55Z<p><span dir="auto"><span class="autocomment">Installation</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 20:08, 11 May 2013</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 6:</td>
<td colspan="2" class="diff-lineno">Line 6:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Installation ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Installation ==</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>To Upgrade to Mysql 5.<del class="diffchange diffchange-inline">1 </del>on CentOS/RHEL/Fedora</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>To Upgrade to Mysql 5.<ins class="diffchange diffchange-inline">5 </ins>on CentOS/RHEL/Fedora</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''Steps 3 and 4 only apply if you are upgrading from MySQL 5.0.x See version differences in following link''' http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-previous-series.html</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''Steps 3 and 4 only apply if you are upgrading from MySQL 5.0.x See version differences in following link''' http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-previous-series.html</div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 14:</td>
<td colspan="2" class="diff-lineno">Line 14:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  wget -q -O - http://www.atomicorp.com/installers/atomic | sh</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  wget -q -O - http://www.atomicorp.com/installers/atomic | sh</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Step 2) Upgrade to Mysql 5.<del class="diffchange diffchange-inline">1</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Step 2) Upgrade to Mysql 5.<ins class="diffchange diffchange-inline">5</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  yum upgrade mysql</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  yum upgrade mysql</div></td></tr>
</table>Mshinnhttps://wiki.atomicorp.com/wiki/index.php?title=Mysql&diff=2065&oldid=prevMshinn: /* Features */2012-01-10T14:52:51Z<p><span dir="auto"><span class="autocomment">Features</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 14:52, 10 January 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Features ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Features ==</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>* Based on Mysql 5.<del class="diffchange diffchange-inline">1</del>.x branch</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* Based on Mysql 5.<ins class="diffchange diffchange-inline">5</ins>.x branch</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Uses the design from Fedora, RHEL, and CentOS</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Uses the design from Fedora, RHEL, and CentOS</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Installation ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Installation ==</div></td></tr>
</table>Mshinnhttps://wiki.atomicorp.com/wiki/index.php?title=Mysql&diff=985&oldid=prevHighland at 13:25, 27 August 20102010-08-27T13:25:14Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 13:25, 27 August 2010</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 42:</td>
<td colspan="2" class="diff-lineno">Line 42:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Known Issues ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Known Issues ==</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">== MySQL Library Differs ==</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">When using some tools (most notably PHPMyAdmin) you may get a notice like this</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"> Your PHP MySQL library version 5.0.90 differs from your MySQL server version 5.1.50. This may cause unpredictable behavior.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">This message can be safely ignored. The reason that the library cannot be upgraded with the server is that, in Enterprise Linux, everything is compiled around the old library. Upgrading the library would break a number of programs compiled against it so, for compatibility's sake, it must remain as the one provided by the vendor directly.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">If you REALLY need the latest libraries you can recompile php from the SRPMS.</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Problems with MySQL databases and PLESK 9 after upgrade ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Problems with MySQL databases and PLESK 9 after upgrade ==</div></td></tr>
</table>Highlandhttps://wiki.atomicorp.com/wiki/index.php?title=Mysql&diff=913&oldid=prevRnolds81: /* Problems with MySQL databases and PLESK 9 after upgrade */2010-07-10T15:34:36Z<p><span dir="auto"><span class="autocomment">Problems with MySQL databases and PLESK 9 after upgrade</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 15:34, 10 July 2010</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 57:</td>
<td colspan="2" class="diff-lineno">Line 57:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Issue the following command from the shell:</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Issue the following command from the shell:</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>  mysqlcheck --check-upgrade --all-databases --auto-repair -<del class="diffchange diffchange-inline">uadmin </del>-p''youradminpassword''</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>  mysqlcheck --check-upgrade --all-databases --auto-repair -<ins class="diffchange diffchange-inline">u admin </ins>-p''youradminpassword''</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>followed by:</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>followed by:</div></td></tr>
</table>Rnolds81https://wiki.atomicorp.com/wiki/index.php?title=Mysql&diff=912&oldid=prevRnolds81: /* Installation */2010-07-10T15:33:32Z<p><span dir="auto"><span class="autocomment">Installation</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 15:33, 10 July 2010</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 27:</td>
<td colspan="2" class="diff-lineno">Line 27:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  mysql_upgrade -u root -p</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  mysql_upgrade -u root -p</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>or for Plesk environments (NOTE - this is the exact same login as the Plesk superuser):</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>or for Plesk environments (<ins class="diffchange diffchange-inline">and then the </ins>NOTE - this is the exact same login as the Plesk superuser <ins class="diffchange diffchange-inline">e.g. use "-u admin" and then your admin password</ins>):</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  mysql_upgrade -u admin -p</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  mysql_upgrade -u admin -p</div></td></tr>
</table>Rnolds81https://wiki.atomicorp.com/wiki/index.php?title=Mysql&diff=907&oldid=prevHighland: /* Installation */2010-06-29T13:15:08Z<p><span dir="auto"><span class="autocomment">Installation</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 13:15, 29 June 2010</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 19:</td>
<td colspan="2" class="diff-lineno">Line 19:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  yum upgrade mysql</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  yum upgrade mysql</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Step 3) MySQL 5.1 removed the BERKLEY storage engine. <del class="diffchange diffchange-inline">As such</del>, <del class="diffchange diffchange-inline">many /etc/my.cnf have the following line inside</del>. You '''must''' comment out or remove <del class="diffchange diffchange-inline">this </del>or MySQL 5.1 '''will not start!'''</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Step 3) MySQL 5.1 removed the BERKLEY storage engine. <ins class="diffchange diffchange-inline">Since it was not commonly used</ins>, <ins class="diffchange diffchange-inline">to save resources it was recommended this be turned off</ins>. You '''must''' comment <ins class="diffchange diffchange-inline">the following </ins>out or remove <ins class="diffchange diffchange-inline">it from /etc/my.cnf </ins>or MySQL 5.1 '''will not start!'''</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  skip-bdb</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  skip-bdb</div></td></tr>
</table>Highlandhttps://wiki.atomicorp.com/wiki/index.php?title=Mysql&diff=906&oldid=prevHighland: /* Installation */2010-06-29T13:11:33Z<p><span dir="auto"><span class="autocomment">Installation</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 13:11, 29 June 2010</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 11:</td>
<td colspan="2" class="diff-lineno">Line 11:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''Steps 3 and 4 only apply if you are upgrading from MySQL 5.0.x See version differences in following link''' http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-previous-series.html</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''Steps 3 and 4 only apply if you are upgrading from MySQL 5.0.x See version differences in following link''' http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-previous-series.html</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Step 1) Set up the <del class="diffchange diffchange-inline">[Getting_Started[</del>atomic channel]]:  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Step 1) Set up the atomic channel <ins class="diffchange diffchange-inline">(See [[Getting_Started</ins>]]<ins class="diffchange diffchange-inline">)</ins>:  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  wget -q -O - http://www.atomicorp.com/installers/atomic | sh</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  wget -q -O - http://www.atomicorp.com/installers/atomic | sh</div></td></tr>
</table>Highlandhttps://wiki.atomicorp.com/wiki/index.php?title=Mysql&diff=905&oldid=prevHighland: /* Installation */2010-06-29T13:09:52Z<p><span dir="auto"><span class="autocomment">Installation</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 13:09, 29 June 2010</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 11:</td>
<td colspan="2" class="diff-lineno">Line 11:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''Steps 3 and 4 only apply if you are upgrading from MySQL 5.0.x See version differences in following link''' http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-previous-series.html</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''Steps 3 and 4 only apply if you are upgrading from MySQL 5.0.x See version differences in following link''' http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-previous-series.html</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Step 1) Set up the atomic channel:  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Step 1) Set up the <ins class="diffchange diffchange-inline">[Getting_Started[</ins>atomic channel<ins class="diffchange diffchange-inline">]]</ins>:  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  wget -q -O - http://www.atomicorp.com/installers/atomic | sh</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  wget -q -O - http://www.atomicorp.com/installers/atomic | sh</div></td></tr>
</table>Highlandhttps://wiki.atomicorp.com/wiki/index.php?title=Mysql&diff=904&oldid=prevHighland: /* Installation */2010-06-29T13:05:01Z<p><span dir="auto"><span class="autocomment">Installation</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 13:05, 29 June 2010</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 9:</td>
<td colspan="2" class="diff-lineno">Line 9:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>To Upgrade to Mysql 5.1 on CentOS/RHEL/Fedora</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>To Upgrade to Mysql 5.1 on CentOS/RHEL/Fedora</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>'''Steps 3 and 4 only apply if you are upgrading from MySQL 5.0.x See version differences in following link''' <del class="diffchange diffchange-inline">[</del>http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-previous-series.html<del class="diffchange diffchange-inline">]</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>'''Steps 3 and 4 only apply if you are upgrading from MySQL 5.0.x See version differences in following link''' http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-previous-series.html</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Step 1) Set up the atomic channel:  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Step 1) Set up the atomic channel:  </div></td></tr>
</table>Highlandhttps://wiki.atomicorp.com/wiki/index.php?title=Mysql&diff=903&oldid=prevHighland: /* Installation */2010-06-29T13:04:31Z<p><span dir="auto"><span class="autocomment">Installation</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 13:04, 29 June 2010</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 7:</td>
<td colspan="2" class="diff-lineno">Line 7:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Installation ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Installation ==</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>To Upgrade to Mysql 5.1 on CentOS/RHEL/Fedora  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>To Upgrade to Mysql 5.1 on CentOS/RHEL/Fedora</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>''Steps 3 and 4 only apply if you are upgrading from MySQL 5.0.x'' [http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-previous-series.html]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">'</ins>''Steps 3 and 4 only apply if you are upgrading from MySQL 5.0.x <ins class="diffchange diffchange-inline">See version differences in following link'</ins>'' [http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-previous-series.html]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Step 1) Set up the atomic channel:  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Step 1) Set up the atomic channel:  </div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 18:</td>
<td colspan="2" class="diff-lineno">Line 19:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  yum upgrade mysql</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  yum upgrade mysql</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Step 3) MySQL 5.1 removed the BERKLEY storage engine. As such, many /etc/my.cnf have the following line <del class="diffchange diffchange-inline">to disable it</del>. You <del class="diffchange diffchange-inline">MUST </del>comment out or remove this or MySQL 5.1 '''will not start!'''</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Step 3) MySQL 5.1 removed the BERKLEY storage engine. As such, many /etc/my.cnf have the following line <ins class="diffchange diffchange-inline">inside</ins>. You <ins class="diffchange diffchange-inline">'''must''' </ins>comment out or remove this or MySQL 5.1 '''will not start!'''</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  skip-bdb</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  skip-bdb</div></td></tr>
</table>Highland