Re: Migration to Scarab 0.21 and MySQL 5.1

I think there was some trick (disabling constraints while the migration
takes place???) that might avoid that problem.Anyway; could you elaborate
which exactly was the problem you got? We might be able to fix the migration
script so constraits don't get in the way...

Regards,

-- 
Jorge Uriarte Aretxaga
http://www.gailen.es
http://www.linkedin.com/in/jorgeuriarte

On Thu, Nov 13, 2008 at 4:10 PM, <[email protected]> wrote:

>
> 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
>