replication ignore delete statement

2003-01-16 Thread CheongMeng
Hi, is it possible to ignore all sql delete statement while doing mysql replication? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

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

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/ __ ___