Migration to Scarab 0.21 and MySQL 5.1
[email protected] Thu, 13 Nov 2008 16:10:31 +0100
| Newsgroups | gmane.comp.java.scarab.user |
|---|---|
| Message-ID | <OF51805D9A.E0EB5EAF-ONC1257500.0051FCDD-C1257500.00535C99@tk-online.de> |
Hello, as apposed to some mailings in this list and to the documentation I was able to successfully migrate a Scarab 0.20 DB to Scarab 0.21 with MySQL 5.1. The only thing is, that you have to ensure to use MyISAM and not InnoDB because of some compatibility issues with constraints. This can be set in the initial configuration of MySQL or may be later changed in some place. MySQL 5 has some advantages, e.g. you can use a free graphical maintenance frontend (GUI Tools). My configuration: Scarab 0.21 Windows Server 2003 Apache Tomcat/6.0.18 JVM: 1.6.0_10-b33 Database: mysql-5.1.29-rc-win32 (community) It is also possible to export the Database from MySQL 5.1 into a MySQL 4.x installtion, migrate it, and reimport it into MySQL 5.1. Viele Grüße Jörg Florin ITS.4 - Systemframeworks