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 <[email protected]> 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 [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > 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 [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.
