Replication Rollback

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

How can you possibly expect us to know more about mysql than the experts
in the mysql list ? :-)

karthikeyan.balasubramanian wrote:

>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
>
>
>


--
Raditha Dissanayake.
------------------------------------------------------------------------
http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload
Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader
Graphical User Inteface. Just 150 KB | with progress bar.

karthikeyan.balasubramanian wrote:

> 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.

That's no excuse. Just wait for an answer and don't bother other lists
because they're "kinda sorta" related...

> 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.

No.

--
---John Holmes...

Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

php|architect: The Magazine for PHP Professionals – www.phparch.com