[otrs-cvs] doc-admin/en/content/installation upgrading.xml, 1.7, 1.8

Comments:
Update of /home/cvs/doc-admin/en/content/installation
In directory lancelot:/tmp/cvs-serv6849/en/content/installation

Modified Files:
	upgrading.xml 
Log Message:
Added mysql storage engine note to the upgrading instructions.

Author: mg

Index: upgrading.xml
===================================================================
RCS file: /home/cvs/doc-admin/en/content/installation/upgrading.xml,v
retrieving revision 1.7
retrieving revision 1.8
diff -2 -u -d -r1.7 -r1.8
--- upgrading.xml	27 Nov 2012 11:31:42 -0000	1.7
+++ upgrading.xml	22 Jan 2013 11:18:40 -0000	1.8
@@ -139,11 +139,26 @@
 # MySQL:
 shell> cat scripts/DBUpdate-to-3.2.mysql.sql | mysql -p -f -u root otrs
+
 # PostgreSQL 8.2+:
 shell> cat scripts/DBUpdate-to-3.2.postgresql.sql | psql otrs
+
 # PostgreSQL, older versions:
 shell> cat scripts/DBUpdate-to-3.2.postgresql_before_8_2.sql | psql otrs
             </screen>
-
-            NOTE: If you use PostgreSQL 8.1 or earlier, you need to activate the new legacy driver
+        </para>
+        <para>
+             Note: new tables created in the MySQL UPGRADING process will be created with the
+             default table storage engine set in your MySQL server.
+             In MySQL 5.5 the new default type is InnoDB.
+             If existing tables, e.g. "users", have the table storage engine e.g. MyISAM,
+             then an error will be displayed when creating the foreign key constraints.
+         </para>
+         <para>
+            You have two options: you can change the default storage engine of MySQL back to MyISAM
+            so that new tables will have the same engine as the existing tables,
+            or change the existing tables to use InnoDB as storage engine.
+        </para>
+        <para>
+            Note: If you use PostgreSQL 8.1 or earlier, you need to activate the new legacy driver
             for these older versions. Do this by adding a new line to your <filename>Kernel/Config.pm</filename> like this:
 
---------------------------------------------------------------------
OTRS mailing list: cvs-log - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/cvs-log
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/cvs-log