Re: Dumping all the sql statements as backup

2012-08-30 Thread Jason Friedman
>> I have some long running processes that do very long simulations which >> at the end need to write things on a database. >> >> At the moment sometimes there are network problems and we end up with >> half the data on the database. >> >> The half-data problem is probably solved easily with sessio

Re: Dumping all the sql statements as backup

2012-08-29 Thread Robert Miles
On 7/25/2012 8:56 AM, andrea crotti wrote: I have some long running processes that do very long simulations which at the end need to write things on a database. At the moment sometimes there are network problems and we end up with half the data on the database. The half-data problem is probably

Re: Dumping all the sql statements as backup

2012-07-25 Thread andrea crotti
2012/7/25 Jack Since you know the content of what the sql code is, why not just build > the sql file(s) needed and store them so that in case of a burp you can > just execute the code file. If you don't know the exact sql code, dump > it to a file as the statements are constructed... The only prob

Re: Dumping all the sql statements as backup

2012-07-25 Thread Jack
On 07/25/2012 09:56 AM, andrea crotti wrote: > I have some long running processes that do very long simulations which > at the end need to write things on a database. > > At the moment sometimes there are network problems and we end up with > half the data on the database. > > The half-data problem

Dumping all the sql statements as backup

2012-07-25 Thread andrea crotti
I have some long running processes that do very long simulations which at the end need to write things on a database. At the moment sometimes there are network problems and we end up with half the data on the database. The half-data problem is probably solved easily with sessions and sqlalchemy (