I misread initially. You are using the script command to produce an SQL
script?
I'm not sure if that would work ? Wouldn't the MVCC isolate so the
changes don't propagate through to the other session?
On 8/05/2015 1:42 PM, Thomas Mueller wrote:
Hi,
> Should I still take my database offline when doing a backup?
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.
Regards,
Thomas
On Friday, May 8, 2015, Ryan How <r...@bitworks.com.au
<mailto:r...@bitworks.com.au>> wrote:
I think you have to turn off the space re-using or something like
that while running the backup?
Maybe that should happen automatically as part of the script tool?
On 8/05/2015 7:48 AM, Rami Ojares wrote:
I tested it out and it seems that the backup becomes completely
corrupted.
So one should reserve the db exclusively for himself and only
then try the backup.
- rami
On 7.5.2015 21:24, Rami Ojares wrote:
Hi,
Now when I have moved to mvcc+multithreaded and do my backup
using Script tool the database stays responsive.
I think before every object was locked during backup.
But I started wondering about the consistency of the backup.
Consider the following scenario.
- Table T1 that has FK referring to T2.
- Backup has already processed T1
- Delete on T2 happens that with cascade mechanism removes a row
from T1
- Backup now processes T2
The backup is now inconsistent because T1 has a row that refers
to a non-existent row in T2.
Is this possible?
Should I still take my database offline when doing a backup?
- 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 h2-database+unsubscr...@googlegroups.com
<javascript:_e(%7B%7D,'cvml','h2-database%2bunsubscr...@googlegroups.com');>.
To post to this group, send email to h2-database@googlegroups.com
<javascript:_e(%7B%7D,'cvml','h2-database@googlegroups.com');>.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
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 h2-database+unsubscr...@googlegroups.com
<mailto:h2-database+unsubscr...@googlegroups.com>.
To post to this group, send email to h2-database@googlegroups.com
<mailto:h2-database@googlegroups.com>.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
