Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

migrated from stackoverflow.com Feb 16 '12 at 16:34

This question came from our site for professional and enthusiast programmers.

    
I'm curious why you would want to do this. I has never heard of hsqldb before this. –  Aaron Brown Feb 17 '12 at 0:30

3 Answers 3

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.

share|improve this answer
    
Phpmyadmin is incredibly heavy weight just to get a schema dump! –  Aaron Brown Feb 17 '12 at 1:13
    
Aaron Brown: That is exacly why I have written: "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." –  Ralph Feb 17 '12 at 7:42

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.

share|improve this answer

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? "
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.