title: How to load mysql dump to hsqldb database?
body: <p>I have a sql file that creates a database in mysql:</p>
  
  <pre><code>SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
  SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
  SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
  
  CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
  USE `mydb` ;
  
  -- -----------------------------------------------------
  -- Table `mydb`.`machine`
  -- -----------------------------------------------------
  CREATE  TABLE IF NOT EXISTS `mydb`.`machine` (
    `id` INT NOT NULL ,
    `name` VARCHAR(45) NULL ,
    PRIMARY KEY (`id`) );
  
  
  SET SQL_MODE=@OLD_SQL_MODE;
  SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
  SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
  </code></pre>
  
  <p>Now I would like to load this file into hsqldb 2 database. What do I need to change in the mysql dump to load the data into hsqldb?</p>
  
  <p>Currently I use this code (groovy) to execute the sql file:</p>
  
  <pre><code>def embeddedDbSettings = [url:'jdbc:hsqldb:file:mydb', user:'sa', password:'', driver:'org.hsqldb.jdbcDriver'];
  sql =  Sql.newInstance(embeddedDb);
  sql.executeInsert new File("./sql/create_database.sql").text;
  </code></pre>
  
  <p>and all the time I got this crypting exception:</p>
  
  <pre><code>Exception in thread "main" java.sql.SQLException: unknown token
      at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
      at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source)
      at groovy.sql.Sql.executeInsert(Sql.java:1440)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)
      at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)
      at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
      at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
      at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:125)
      at de.hpi.ecir.eval_script.Convert2Excel.main(Convert2Excel.groovy:37)
  Caused by: org.hsqldb.HsqlException: unknown token
      at org.hsqldb.error.Error.error(Unknown Source)
      at org.hsqldb.error.Error.error(Unknown Source)
      at org.hsqldb.ParserBase.read(Unknown Source)
      at org.hsqldb.ParserDDL.compileCreate(Unknown Source)
      at org.hsqldb.ParserCommand.compilePart(Unknown Source)
      at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
      at org.hsqldb.Session.executeDirectStatement(Unknown Source)
      at org.hsqldb.Session.execute(Unknown Source)
      ... 13 more
  </code></pre>