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
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 can i do that?
My current file my.conf on slave is as follows:
[
Hi,
I have a question about Mysql replication,
I wanted to know how can I replicate a part of a Table data between 2 databases
in mysql4, and not the all tables data.
I already set mysql replication between the databases, and its worked fine,
But I need to filter data to replicate based on custom
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
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)
Rémy BONNET.
Yahoo! Mail : votre e-mail personnel et gratuit qui vous suit partou