>> I would stay away from any of the do-db or ignore-db settings.
>>
>
> Can you explain, why?
They are dangerous. Search the list archives, I wrote a diatribe
about it a while back.
Cheers
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
Baron Schwartz schrieb:
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...
On the slave side, use --r
> 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...
On the slave side, use --replicate-wild-do-ta
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
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...
T
No, I'm afraid not.
- michael dykman
On Sat, Apr 18, 2009 at 7:11 AM, Uwe Kiewel 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://li
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=arch...@jab.org
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Sanjeev Sagar [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 02, 2004 4:04 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc: Sanjeev Sagar
> Subject: Binlog quest
Hello everyone,
I have a question on how MySQL database write to binlogs in replication
environment. My table type is MyISAM. MySQL version is 4.0.21.
I have a replication farm. Let's suppose I am running a ALTER TABLE
statement on central master and had a syntax error in table name.
Replic
