You can do with one line:
replicate-do-table = db.table1, db.table2, db.table3
----- Original Message -----
From: "Rob Gormley" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Monday, February 27, 2006 10:35 PM
Subject: Elementary replication
Hi,
Not having a lot of luck with replication.
Have 2 4.1x boxes
Slave is configured, via my.cnf, to only replicate three tables:
replicate-do-table = db.table1
replicate-do-table = db.table2
replicate-do-table = db.table3
SHOW SLAVE STATUS; (sanitised) output is as follows:
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: db0.xxx
Master_User: xxx
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.001305
Read_Master_Log_Pos: 10165261
Relay_Log_File: db2-relay-bin.000002
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.001305
Slave_IO_Running: No
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table: db.table1,db.table2,db.table3
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 10165261
Relay_Log_Space: 4
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
1 row in set (0.00 sec)
Master position was set with "CHANGE MASTER TO
MASTER_LOG_FILE='mysql-bin.001305', MASTER_LOG_POS = 10165261"
to deal with restoring a mysqldump, and using a running server (I'd
really like to avoid shutting down the master)
Replication has never been run on this machine.
Where can I go from here to get it running?
Rob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]