Hi ! Just read about the possibility of replicating two databses. Can you tell me how to do it or send me a (link to a) manual?
Thanks, Sven On Monday, May 6, 2002, at 03:11 PM, Dicky Wahyu Purnomo wrote: > On Mon, 6 May 2002 07:44:04 +0200 > "Ewan Sadie" <[EMAIL PROTECTED]> wrote: > >> I have installed MySQL on two of my MS-Proxy servers. I am logging all >> web browser logs to MySQL. >> I want to replicate the database to a central server where I can do >> queries on the data. I do not want to run select statement agains the >> proxy server itself. >> How can I replicate the data to a different server (like with slave >> master replication) and then delete the data on the proxy server, >> without deleting it on the central server. >> What I actually want to do is something like a selecy into but between >> different server/databases. >> >> I am evaluation MySQL and if I can get this right I will chuck out my >> MS-SQL databases. > > From my experience, I can tell you this : > > Master ------------------> Slave > Replication > > Every query that change the data on master will be replicated on slave. > > But I think you can try this : > binlog-db : DB_A > biglog-ignore-db : DB_B > > DB_A is the database which will be replicated. > > you can do the "delete" query with using "DB_B" database, > e.g. : "use DB_B; delete from table DB_A.Table_A;" > > Correct me if i'm wrong ... ;-) > > -- > We are using Linux daily to UP our productivity - so UP yours! > -- Adapted from Pat Paulsen by Joe Sloan > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <mysql-unsubscribe- > [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
