Perhaps the best thing to do is get another server, one that is only for
testing, hook it up as a slave to your master and then experiment on your
own.
On Sun, Dec 21, 2008 at 2:25 PM, Sergio Belkin wrote:
> 2008/12/21 Baron Schwartz :
> > On Wed, Dec 17, 2008 at 7:17 AM, Sergio Belkin wrote:
>
2008/12/21 Baron Schwartz :
> On Wed, Dec 17, 2008 at 7:17 AM, Sergio Belkin wrote:
>> Hi,
>>
>> I use mysql 5.0 (Centos 5.2) , I have a database, say called opfilter
>> with 2 tables (say aliases and hosts) and I want that slave only
>> replicate tabla aliases and only records from table hosts t
On Wed, Dec 17, 2008 at 7:17 AM, Sergio Belkin wrote:
> Hi,
>
> I use mysql 5.0 (Centos 5.2) , I have a database, say called opfilter
> with 2 tables (say aliases and hosts) and I want that slave only
> replicate tabla aliases and only records from table hosts that match a
> given criteria, how c
You can suppress writing the delete query to the binary log.
mysql>set sql_log_bin = 0;
mysql>delete ... ;
mysql>set sql_log_bin=1;
Bonnet R?my <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a database which is flushed every four hours,
> and
> I want to replicate it without replicating the del
Bonnet R?my <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a database which is flushed every four hours,
> and
> I want to replicate it without replicating the delete
> queries . Is this possible ?
> (sorry for my awful english)
With mysqlbinlog utility or with SHOW BINLOG EVENTS statement find n
