How to Import MySQL to HSQLDB

HSQLDB is a Javascript-based relational database platform, similar to MySQL. Standing for Hyper Structured Query Language Database, HSQLDB comes embedded with a web server, command line interface and a graphical user interface if you don't want to use the command line to manage the database. Just like MySQL, HSQLDB is an open-source database platform. Using the RazorSQL HSQLDB Import Tool, you can import MySQL databases into HSQLDB databases.

Things You'll Need

• RazorSQL Import Tool
• MySQL database file

Instructions

1. Launch the RazorSQL Import Tool by double-clicking the application icon in your Applications folder.

2. Click on the drop-down menu next to the "Delimiter" option and select "<COMMA>."

3. Click on "Browse" next to the "Delimited File" field, then locate and select the MySQL database file that you wish to import.

4. Configure the rest of the import tool by entering in values into the file start and end rows, if you wish to only import a portion of the SQL database, for example. Select the column names which you wish to import, and then click on "Next" to begin the import.

5. Allow the import to complete before attempting to access it from HSQLDB.

References

• HSQLDB: User Guide
• RazorSQL: HSQLDB Import Tool