Replication Rollback

From: Date: Mon, 29 Dec 2003 11:10:28 +0000
Subject: Replication Rollback
Groups: php.general 
Request: Send a blank email to php-general+get-173422@lists.php.net to get a copy of this message
Hi, I posted this question in MySQL mailing list and go no reply. Since PHP is so close to MySQL. I am posting this question here. 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 Karthikeyan B

« previous php.general (#173422) next »