sKQchJmK

1H2 database script cannot be imported into MySQL
2SET LOCK_MODE 3;
3;             
4CREATE USER IF NOT EXISTS SA SALT '...' HASH '...' ADMIN;           
5CREATE CACHED TABLE PUBLIC.RAWVALUEITEM(
6    LANGUAGE VARCHAR(2) NOT NULL SELECTIVITY 1,
7    RAWVALUE VARCHAR(40) NOT NULL SELECTIVITY 99,
8    STRIPPED VARCHAR(40) NOT NULL SELECTIVITY 96
9);
10...
11	
12#1193 - Unknown system variable 'LOCK_MODE'
13	
14#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS SA SALT '...' HASH '...' at line 1
15	
16public static final String DB_DIR_LOCATION = "E:/Temp/FWDB/";
17public static final String H2_CONNECTION = "jdbc:h2:file:"
18    + DB_DIR_LOCATION + "FWDB_PHP_TEST" + "Mode=MySQL;IFEXISTS=TRUE";
19
20public static void main(String[] args) throws SQLException {
21
22    Connection conn = DriverManager.
23        getConnection(H2_CONNECTION, "sa", "");
24
25    PreparedStatement ps;
26
27    ps = conn.prepareStatement("SCRIPT TO 'E:/Temp/FWDB/FWDB_EXPORT.gz' " 
28        + "COMPRESSION GZIP");
29    ps.execute();
30
31}