You can configure your master to only write specific  databases or
tables to the bin log, if you only expect to replicate a subset.  As
normal practice, I always make my configuration as specific as
possible.

see
http://dev.mysql.com/doc/refman/5.0/en/replication-options-binary-log.html

and look for binlog-do-db

 - michael dykman


On Sat, Apr 18, 2009 at 12:10 PM, Uwe Kiewel <m...@kiewel-online.ch> wrote:
> Michael Dykman schrieb:
>>
>> No, I'm afraid not.
>
> So, how it's possible to replicate one specific db? I have 4 db's writing
> into binlog. I need only one of them at client site. After the successful
> setup of the replication I get errors on client site like no such table, no
> such database etc...
>
> Thanks,
>        Uwe
>>
>>  - michael dykman
>>
>> On Sat, Apr 18, 2009 at 7:11 AM, Uwe Kiewel <m...@kiewel-online.ch> wrote:
>>>
>>> Hi,
>>>
>>> is it possible to have separated binlogs for each mysql-db?
>>>
>>> Thanks,
>>>   Uwe
>>>
>>> --
>>> MySQL General Mailing List
>>> For list archives: http://lists.mysql.com/mysql
>>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com
>>>
>>>
>>
>>
>>
>
>



-- 
 - michael dykman
 - mdyk...@gmail.com

 - All models are wrong.  Some models are useful.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to