Do you have control over your DELETE queries? If so, 'SET SQL_LOG_BIN=0' would be an easy implementation.
A common approach in my experience is to have a script query the master and archive data to a second database before any deletes are done. If you have no control over the DELETE queries and when they occur, you may have to look into parsing the binlogs yourself... Atle - Flying Crocodile Inc, Unix Systems Administrator On Fri, 7 Apr 2006, Ian Collins wrote: > Hi, > I have a customer who wants to be able to replicate their live MySQL > database to a second server, but not to have any data deleted. > i.e., they want to accumulate the data. > > I don't believe you can do this with replication. Does anyone know a way > of doing this? > > Cheers, > Ian. > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
