No, replication is not designed for this task.
It sounds like the Archive Storage Engine could be a good solution for you:
http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html
Robin Schumacher has written a nice introductory article:
http://dev.mysql.com/tech-resources/articles/storage-engine.html
Hope that helps,
Eric
--
Eric Braswell
Web Manager MySQL AB
Cupertino, USA
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]
