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