HSQLDB migration to MySQL is not out of the box supported by mysql. The MySQL Workbench can only handle with dumps made by other mysql server. HSQLDB Transfer Tool is no longer bundled with the standard hsqldb jar file in the 1.8.x or later releases. After downloading and building with
ant hsqldbutil
you get in lib an additional hsqldbutil jar. With the hsqldb.jar, the hsqldbutil.jar and and mysql connector jar in my classpath i tried the Database Manager (From Tools menu choose transfer) from hsql with no luck. The MySQL Migration Toolkit has reached the EOL phase but works perfect for me. After downloading add the hsqldb jar to the lib folder C:\Program Files (x86)\MySQL\MySQL Tools for 5.0\java\lib. I update as well the mysql connector to the latest one.
- Start your hsqldb server from command line
- java -cp hsqldb-1.8.0.10.jar org.hsqldb.Server -database <path to your hsqldb files>\<database name>
- Start MySQL Migration Toolkit
- Choose direct migration
- Choose as Source a generic jdbc
- Enter “org.hsqldb.jdbcDriver” as classname
- Enter “jdbc:hsqldb:hsql://localhost” as connection string
- Enter “sa” as username and leave password empty
- click next
- Configure your mysql connection
- click next
- choose public as schema
- click next several time till screen “object creation options”
- choose “create script file..” instead of “create objects online”
- click next several time till screen “data mapping options”
- choose “create script file..” instead of “transfer data online”
- click next several time till screen “Summary”
- click finish
With the sql you can use tools like phpmyadmin or the mysql workbench to import your data into the mysql server.