Re: Replication only DB

2005-03-11 Thread Eric Bergen
Remember replicate-do-db doesn't look at queries to decide which ones to replicate. It only looks at the USE flag. This is very important: http://dev.mysql.com/doc/mysql/en/replication-options.html> Tells the slave to restrict replication to statements where the default database (that is, the one

Re: Replication only DB

2005-03-11 Thread Peter Brawley
replicate-do-db came in with 3.23.16, and it's in the manual (though the online search engine mishandles a search for 'replicate-do-db'--look under 'Replication startup options'). PB - Steve Buehler wrote: At 02:35 AM 3/11/2005, you wrote: You can simply specify the database: --replicate-do-

Re: Replication only DB

2005-03-11 Thread SGreen
Steve Buehler <[EMAIL PROTECTED]> wrote on 03/11/2005 10:10:57 AM: > At 02:35 AM 3/11/2005, you wrote: > > >You can simply specify the database: > > > >--replicate-do-db=db_name > > Stupid/Not so Stupid question here. What mysql program has that option? I > searched mysql.com and couldn't fi

Re: Replication only DB

2005-03-11 Thread Steve Buehler
At 02:35 AM 3/11/2005, you wrote: You can simply specify the database: --replicate-do-db=db_name Stupid/Not so Stupid question here. What mysql program has that option? I searched mysql.com and couldn't find it. I have looked at the man pages for mysql, mysqld, mysqladmin and mysqldump and did

Re: Replication only DB

2005-03-11 Thread Deluxe Web
You can simply specify the database: --replicate-do-db=db_name On Fri, 11 Mar 2005 09:24:38 +0100, Arcangelo Casavola <[EMAIL PROTECTED]> wrote: > Hi, > > I've master with mysql 4.1.10 > slave with mysql 4.0.18 > > On my two servers i have many database, can I do a replication of only 1 DB? >

Replication only DB

2005-03-11 Thread Arcangelo Casavola
Hi, I've master with mysql 4.1.10 slave with mysql 4.0.18 On my two servers i have many database, can I do a replication of only 1 DB? thank Arcangelo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]