Re: [h2] How to restore h2 database

2018-05-01 Thread Kerry Sainsbury
Are you restoring into an empty database? On 2 May 2018 at 15:17, Syed Nabi wrote: > How to restore a backup of h2 database in java. I store the backup on > > statement.execute(String.format("SCRIPT TO '%s'","path.sql")); > > but I don't know how to restore this backup I tried > > statement.exec

[h2] How to restore h2 database

2018-05-01 Thread Syed Nabi
How to restore a backup of h2 database in java. I store the backup on statement.execute(String.format("SCRIPT TO '%s'","path.sql")); but I don't know how to restore this backup I tried statement.execute(String.format("RUNSCRIPT FROM '%s'", "path.sql")); but it gives me an error: org.h2.jdbc.J