[otrs-cvs] otrs UPGRADING,1.88,1.89
"CVS commits notifications of OTRS.org" <[email protected]>
| Newsgroups | gmane.comp.otrs.cvs |
|---|---|
| Message-ID | <[email protected]> |
Comments:
Update of /home/cvs/otrs
In directory lancelot:/tmp/cvs-serv6871
Modified Files:
UPGRADING
Log Message:
Added mysql storage engine note to the upgrading instructions.
Author: mg
Index: UPGRADING
===================================================================
RCS file: /home/cvs/otrs/UPGRADING,v
retrieving revision 1.88
retrieving revision 1.89
diff -2 -u -d -r1.88 -r1.89
--- UPGRADING 10 Jan 2013 15:10:37 -0000 1.88
+++ UPGRADING 22 Jan 2013 11:18:51 -0000 1.89
@@ -98,4 +98,14 @@
shell> cat scripts/DBUpdate-to-3.2.mysql.sql | mysql -p -f -u root otrs
+ 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.
+
+ 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.
+
PostgreSQL 8.2+:
shell> cat scripts/DBUpdate-to-3.2.postgresql.sql | psql otrs
---------------------------------------------------------------------
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