Unfortunately this didn't work. There were a lot of exceptions of missing LOBs, and after appending "- continueOnError" option to the RunScript tool I've got an incomplete database.
On Oct 6, 10:43 am, Michael <[email protected]> wrote: > I will try it now. The database is encrypted, so I guess the steps > should be: > > 1. Decrypt database: > > java -cp h2*.jar org.h2.tools.ChangeFileEncryption -dir . -db > database -cipher AES -decrypt pwd > > 2. Run the recover tool: > > java -cp h2*.jar org.h2.tools.Recover > > 3. Delete the old database: > > for i in *.db ; do mv $i $i.bak; done > > 4. Re-create the database from the script: > > java org.h2.tools.RunScript -url jdbc:h2:database -user user - > password pwd -script database*.sql > > 5. Encrypt the database: > > java -cp h2*.jar org.h2.tools.ChangeFileEncryption -dir . -db > database -cipher AES -encrypt pwd > > If the steps above are correct I should succeed :-) I'll report back > if anything goes wrong. > > Thanks, > Michael > > On Oct 5, 9:08 pm, zenixan <[email protected]> wrote: > > > > > > > > > Hi, > > Did you use the recovery > > tool?http://www.h2database.com/html/advanced.html#using_recover_tool -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
