Friday, November 07, 2003, 2:51:10 AM, Brian Keck wrote: BK> On Thu, 06 Nov 2003 11:01:31 +0200, Victoria Reznichenko wrote: >>Brian Keck <[EMAIL PROTECTED]> wrote: >>... >>>The replication is limited to a database called mipradius by a slave config >>>'replicate-do-db=myradius', though the master sends updates for all databases >>>... >>What is your current db? Option 'replicate-do-db' means that only commands >>where current database 'myradius' will be replicated.
BK> That's what I want, unless I misunderstand. BK> The slave's copy of the binary log contains sequences like ... BK> use syslog; BK> ... BK> SET TIMESTAMP=1068151258; BK> INSERT DELAYED INTO syslog ... BK> ... BK> use mipradius; BK> SET TIMESTAMP=1068161574; BK> insert into mipsessions ... BK> I want it to ignore the syslog insertions (there is no syslog db on the BK> slave), but apply the mipradius insertions (there is a mipradius db on BK> the slave, copied from the master via tar as described in the manual, BK> section 4.10.4, which I followed pretty closely). BK> Doesn't 'use mipradius' make mipradius the current database? Yes, 'mipradius' is a current database and if you use option 'replicate-do-db=mipradius', 'insert into mipsessions ..' query should be replicated. But in the first post you said about database 'myradius', is this a typo? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]