File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JForum and the fly likes Migrating JForum data HSQLDB -> MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Migrating JForum data HSQLDB -> MySQL" Watch "Migrating JForum data HSQLDB -> MySQL" New topic

Migrating JForum data HSQLDB -> MySQL

Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Has anyone had any experience of migrating JForum data from HSQLDB to MySQL?

We set up our forum in a hurry some time ago, and HSQLDB was the quickest option, but now we want to move the data into our MySQL database (as well as integrate it into out web app via SSO).

Is it just a matter of dumping the HSQLDB table contents and inserting them into the corresponding MySQL ones? If anyone had advice I would be very grateful.

[originally posted on by bengarrett1971]
I agree. Here's the link:
subject: Migrating JForum data HSQLDB -> MySQL
Similar Threads
Help for migrating from HSQLDB to MySQL?
Corruption - after restart, getting HTTP 500
Issues around unit testing MySQL DAO code using HSQLDB.
Importing data from vbulletin
SQL Server support and migrating from HSQLDB to MS SQL