re: replication ignore delete statement

2003-01-16 Thread Victoria Reznichenko
On Thursday 16 January 2003 12:16, CheongMeng wrote: > is it possible to ignore all sql delete statement while doing > mysql replication? Nope. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___

RE: replication ignore delete statement

2003-01-16 Thread James Moore
You could do something like have a process periodically run the non-delete queries in the logs against another database and replicate the second database. Wouldn't be automatic, but you'd have as much control as you like over what goes in the other db. Depending on what you're trying to do, it ma