Re: Examples of savepoints and transactions

2018-01-24 Thread shawn l.green
l machine) snapshot, and revert to that after the tests. Filesystem snapshots will require your database to be stopped and started, though. /Johan - Original Message - From: "Lars Nielsen" To: "MySql" Sent: Tuesday, 23 January, 2018 23:19:29 Subject: Re: Examples of

Re: Examples of savepoints and transactions

2018-01-24 Thread Lars Nielsen
Kind Regards / Med venlig hilsen Lars Nielsen > - Original Message - >> From: "Lars Nielsen" >> To: "MySql" >> Sent: Tuesday, 23 January, 2018 23:19:29 >> Subject: Re: Examples of savepoints and transactions > >>> D

Re: Examples of savepoints and transactions

2018-01-24 Thread Johan De Meersman
em snapshots will require your database to be stopped and started, though. /Johan - Original Message - > From: "Lars Nielsen" > To: "MySql" > Sent: Tuesday, 23 January, 2018 23:19:29 > Subject: Re: Examples of savepoints and transactions > Den 22-01

Re: Examples of savepoints and transactions

2018-01-23 Thread Lars Nielsen
Den 22-01-2018 kl. 22:01 skrev shawn l.green: Hello Lars, On 1/21/2018 3:37 PM, Lars Nielsen wrote: Hi, I have a system that uses begin and commit transactions. It works like a dream! ;) Now I want to test it by creating test data. This how ever cannot be rolled back. I think the solution for

Re: Examples of savepoints and transactions

2018-01-22 Thread shawn l.green
Hello Lars, On 1/21/2018 3:37 PM, Lars Nielsen wrote: Hi, I have a system that uses begin and commit transactions. It works like a dream! ;) Now I want to test it by creating test data. This how ever cannot be rolled back. I think the solution for rolling back test data is to use savepoints an