title: Running h2 in MODE=MySQL doesn't support MySQL dumps
body: <p>I'm trying to embed h2 to test my mysql-application (integration-test)</p>
  
  <p>I added com.h2database:h2:1.3.170 via maven and run the following code:</p>
  
  <pre><code>public class InMemoryTest
  {
      @Test
      public void test() throws Exception {
        Class.forName("org.h2.Driver");
  
        Connection conn = DriverManager.
            getConnection("jdbc:h2:mem:test;MODE=MySQL;IGNORECASE=TRUE;INIT=RUNSCRIPT FROM 'src/test/resources/test.sql'");
      }
  }
  </code></pre>
  
  <p>which gives me the following Exception:</p>
  
  <pre><code>Syntax error in SQL statement "
  CREATE TABLE IF NOT EXISTS ""usr_avatar"" (
    ""usr_avatar_id"" INT(11) NOT NULL AUTO_INCREMENT,
    ""usr_avatar_user_id"" INT(11) NOT NULL,
    ""usr_avatar_img"" BLOB NOT NULL,
    PRIMARY KEY (""usr_avatar_id""),
    UNIQUE KEY ""usr_avatar_id_UNIQUE"" (""usr_avatar_id""),
    UNIQUE KEY ""usr_avatar_user_id_UNIQUE"" (""usr_avatar_user_id""),
    KEY ""usr_user_id"" (""usr_avatar_user_id""),
    KEY ""fk_user_id"" (""usr_avatar_user_id"")
  ) AUTO_INCREMENT[*]=1  ";
  </code></pre>
  
  <p>Apparently, the "AUTO_INCREMENT" causes this?</p>
  
  <p>Since this is valid MySQL (I exported the dump from my real database using MySQL Workbench), I'm a bit confused since h2 claims to support MySQL?
  Here are a few lines from the .sql:</p>
  
  <pre><code>DROP TABLE IF EXISTS `usr_avatar`;
  CREATE TABLE IF NOT EXISTS "usr_avatar" (
    "usr_avatar_id" int(11) NOT NULL AUTO_INCREMENT,
    "usr_avatar_user_id" int(11) NOT NULL,
    "usr_avatar_img" blob NOT NULL,
    PRIMARY KEY ("usr_avatar_id"),
    UNIQUE KEY "usr_avatar_id_UNIQUE" ("usr_avatar_id"),
    UNIQUE KEY "usr_avatar_user_id_UNIQUE" ("usr_avatar_user_id"),
    KEY "usr_user_id" ("usr_avatar_user_id"),
    KEY "fk_user_id" ("usr_avatar_user_id")
  ) AUTO_INCREMENT=1 ;
  
  DROP TABLE IF EXISTS `usr_restriction`;
  CREATE TABLE IF NOT EXISTS "usr_restriction" (
    "usr_restriction_id" int(11) NOT NULL AUTO_INCREMENT,
    "usr_restriction_user_id" int(11) DEFAULT NULL,
    "usr_restriction_ip" varchar(39) DEFAULT NULL,
    "usr_restriction_valid_from" date NOT NULL,
    "usr_restriction_valid_to" date DEFAULT NULL,
    PRIMARY KEY ("usr_restriction_id"),
    UNIQUE KEY "usr_restriction_id_UNIQUE" ("usr_restriction_id"),
    KEY "user_id" ("usr_restriction_user_id"),
    KEY "usr_user_id" ("usr_restriction_user_id")
  ) AUTO_INCREMENT=1 ;
  </code></pre>
  
  <p>What are my options? Should I export the dump with a different software and force it to be plain SQL? Which software could do that? Or am I doing something wrong?</p>