en-US/DatabaseServers.xml

[John J. McDonough]

 en-US/DatabaseServers.xml |   34 +++++++++++++++++++++++++++++-----
 1 file changed, 29 insertions(+), 5 deletions(-)

New commits:
commit 53faee62697cc78f45821408530089520bbba0f2
Author: John J. McDonough <jjmcd at fedoraproject.org>
Date:   Thu Apr 30 17:41:44 2009 -0400

    Changes to Database Servers from wiki
    
    Added significant new content to MySQL
    Minor clarifications and typos in PostgreSQL

diff --git a/en-US/DatabaseServers.xml b/en-US/DatabaseServers.xml
index be12239..b20104c 100644
--- a/en-US/DatabaseServers.xml
+++ b/en-US/DatabaseServers.xml
@@ -13,22 +13,46 @@
 
   <variablelist>
     <varlistentry>
-      <term>mysql</term>
+      <term>MySQL</term>
       <listitem>
         <para>
-          MySQL has been updated to 5.1.31.
+          <package>mysql</package> has been updated to 5.1.31.  This
+          represents a major version upgrade from Fedora 10's 5.0.x
+          release series.
+	</para>
+	<para>
+	  You should test database-using applications for possible
+	  incompatibilities.  Upstream's release notes can be found at
+	  <ulink type="http"
+	  url="http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html"
+	  />.
         </para>
+	<para>
+	  If you are upgrading a Fedora 10 installation that includes
+	  a live 5.0.x MySQL database, don't forget to run
+	  mysql_upgrade after completing the software upgrade.  There
+	  is a <ulink type="http"
+	  url="https://bugzilla.redhat.com/show_bug.cgi?id=493160">
+	  report</ulink> that this may fail altogether if the 5.0.x
+	  database had been updated from an even older installation
+	  without running mysql_upgrade at the time.  If you think
+	  this might be the case for your database, it is prudent to
+	  run mysql_upgrade on the Fedora 10 installation before
+	  upgrading.  (And, of course, you should have backups if the
+	  database content is at all critical.)
+	</para>
       </listitem>
     </varlistentry>
 
     <varlistentry>
-      <term>postgresql</term>
+      <term>PostgreSQL</term>
       <listitem>
         <para>
-          Fedora 11 includes version 8.3.6 of postgreSQL. A
+          Fedora 11 includes version 8.3.7 of postgreSQL. A
           dump/restore is not required for those running
           8.3.X. However, it is recommended to REINDEX all GiST
-          indexes after the upgrade.
+          indexes after the upgrade.  If your Fedora 9 or 10
+	  installation is up to date, there will be no change.
         </para>
       </listitem>
     </varlistentry>