[Building Sakai] Export from HSQLDB to MySQL

[Matthew Jones]

This isn't a sakai specific problem, there are a few ideas out on the
net that have suggestions for accomplishing this. The links below
mentions a Mysql Migration toolkit.

The sakai standard db location as specific in the properties file is
jdbc:hsqldb:file:${sakai.home}db/sakai.db;hsqldb.default_table_type=cached

http://wiki.alfresco.com/wiki/Migrating_from_HSQL
http://dev.mysql.com/doc/migration-toolkit/en/index.html

Let us know how it goes.

-Matthew

On Tue, Jul 28, 2009 at 11:22 AM, Tony Harris<harrist at ccv.vsc.edu> wrote:
> Hi all,
>
> I'm not totally sure this is the right place to post this, but if not maybe
> someone can point me at another more appropriate list.
>
> We have the 2.5.4 Demo installed and have been messing around with it. We're
> closing in on the time when our little demo will need to grow up to be an
> actual pilot-worthy system, but we don't want to lose the few things and
> settings we've done so far.  Is there a way to dump the HSQLDB tables,
> ideally to SQL CREATE and INSERT statements, so I can then configure a Sakai
> instance to use MySQL, import the data, and not lose what we've done?
>
> Once I get that part done I'll plan to upgrade the instance to Sakai 2.6.x
> so we're piloting with the latest and greatest.
>
> Thanks!
>
> --
> Tony Harris
> Assistant CTO
> Community College of Vermont
> harrist at ccv.edu
> (802) 828-2800
>
> Dwirze ski, evarre kolex.
> (One by one droplets, eventually an ocean.)
> -------------------------------------------
> PRIVACY & CONFIDENTIALITY NOTICE: This message is for the designated
> recipient only and may contain privileged, confidential, or otherwise
> private information. If you have received it in error, please notify the
> sender immediately and delete the original. Any other use of an email
> received in error is prohibited.
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org
> with a subject of "unsubscribe"
>