Either this, or use the "backup" SQL statement. With the MVStore
storage, this should work very well. With the PageStore, it should
also work, but I didn't test as much.
I tried the BACKUP command and it seems to work.
Then I made one test.
I started the BACKUP sql command.
While it was running, I inserted one single row into a table.
I restored the backup.
But I could still see the row that was inserted while the backup was
running.
Documentation says:
"Objects are not locked, but the backup is transactionally consistent
because the transaction log is also copied."
I don't know how to interpret this.
What updates do make it in the backup and which ones do not?
- Rami
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
