Currently I am using the H2 database in embedded mode for one of our
applications and there is a need to create a backup/restore
procedure. The requirement is the backup needs to be performed
online.
I backed up the database (while it is on) by creating a SQL statement
file using the Script tool:
java -cp h2*.jar org.h2.tools.Script -url ....
Then I reconstructed the database using the backup SQL statement file
and the RunScript tool:
java -cp h2*.jar org.h2.tools.RunScript ...
No error was encountered during this process. However, users, which is
part of the data store in the database, for the application can no
longer logon. Sometimes, I can't even start up my application
properly. I had to restore the database using the backup I made (by
copying the database files while it's offline) then the application
starts up properly and user are able to logon to the application.
Had any one have problems with the database reconstructed from the SQL
statement backup file?
Any feedback would be greatly appreciated.
--
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.
