How to migrate from MySql to HSQLDB?

Question

I have large amount of data in a MySQL database.

There are many databases schemas in the database.

How I can migrate from MySQL to HSQLDB?

Is there some tool for this?

I've exported the data manually. How can I export only schema.sql?

Answer 1

PhpMyAdmin (Requires a Web Server with PHP) is a tool that is able to create SQL Scripts for Schema and Data. -- The good thing is, it creates SQL scripts, so you can insert the Schema and data to the most other SQL Databases.

So if you have it already installe then you can use it. If you do not have it installed jet, then I would search for an other tool.

Answer 2

Take a look at Comparison of database tools, there you find some tools supporting both HSQL and MySQL. Then it should be possible to export the MySQL DB and directly import to HSQL DB from the same GUI.

Answer 3

mysqldump -d --all-databases -u root -p > schema.sql will dump your schema without data. Use man mysqldump and mysqldump -h to see what other options are available.

two questions, though...

1. Why?
2. What do you consider "very big? "