Hello All,
I set up replication between 2 servers recently. I just need one db to be
replicated and the SHOW SLAVE STATUS shows this:
Relay_Master_Log_File: gyana01-bin.02
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB: tallydb,tallydb
Now the problem is that there is anoth
Hello All,
I need to add a couple of more tables to the list of tables to be replicated
from a particular db in the salve my.cnf.
Can this be done without restarting the mysql server on the slave?
Thanks & regards,
Ratheesh
Running this statement on the master should do it:
DROP TABLE table1, table2...;
That will remove the tables.
Baron
Ratheesh K J wrote:
Hello all,
I cannot afford to stop my slave server. I have list of tables of the master
that are being replicated on the slave.
Now I want to remove a cou
Hello all,
I cannot afford to stop my slave server. I have list of tables of the master
that are being replicated on the slave.
Now I want to remove a couple of tables from this list without affecting the
master and slave. How is this possible?
Thanks & regards,
Ratheesh
Ratheesh K J schrieb:
Thanks,
It helped me a lot. I wanted to know
1. what are the various scenarios where my replication setup can
fail? (considering even issues like network failure and server
reboot etc). What is the normal procedure to correct the failure
when somethi
uot;Ratheesh K J" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, October 02, 2007 4:16 PM
Subject: Re: [Replication] - urgent
> Ratheesh K J schrieb:
>> Hello all,
>>
>> I issued a create table statement on the master for a table which was not
>> present on the mast
Ratheesh K J schrieb:
Hello all,
I issued a create table statement on the master for a table which was not
present on the master but present on the slave.
I did this purposely to see the error on slave.
I am a newbie to replication. Now when i see SLave status on the slave machine
it shows th
Hello all,
I issued a create table statement on the master for a table which was not
present on the master but present on the slave.
I did this purposely to see the error on slave.
I am a newbie to replication. Now when i see SLave status on the slave machine
it shows that the SQL Thread has st