Hi Chris, Thank you for you quick reply.
Is there any alternative way to get back to the old state of the database? Looking forward for your response. Karthikeyan B ----- Original Message ----- From: "Chris" <[EMAIL PROTECTED]> To: "karthikeyan.balasubramanian" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, January 02, 2004 1:33 PM Subject: RE: Rollback > I'm fairly sure there is *no* way to do it. COMMIT says 'I want this data in > the database' not 'I think I want this data in the database' > > Chris > > -----Original Message----- > From: karthikeyan.balasubramanian > [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 01, 2004 11:37 PM > To: [EMAIL PROTECTED] > Subject: Rollback > > > Hi, > > I posted this question in MySQL mailing list and got no reply. > > The basic problem is that I have committed the transaction and then > replicated to another DB. Now I want to rollback the committed transaction. > Is there a way to rollback to a particular point. This requirement is very > similar to rolling back using save points. I guess an option would be to > backup database before changes and restore it if the user is not satisfied > with the changes he has made. One transaction in my application would affect > 6-8 tables with at least 50 - 100 records getting inserted/updated or > deleted. > > Please advice > > PS : Wish you all a very Happy New Year > > Karthikeyan B > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
