Hi,
we use mysql with replication, all works fine.
Now we wan't exclude some tables from the replication.
I enter in my.cnf the line
binlog-ignore-db = news
(stop the master and restart the master after the change in my.cnf)
After this, the master don't repliacted any databases,
only the tables on the master db are updated.
If i enter in mysql "show master status;"
i get following result:
+-----------------+----------+--------------+------------------+
| File | Position | Binlog_do_db | Binlog_ignore_db |
+-----------------+----------+--------------+------------------+
| sumatra-bin.014 | 73 | | news |
+-----------------+----------+--------------+------------------+
1 row in set (0.01 sec)
on thew slave i get:
mysql> show slave status;
+-------------+-------------+-------------+---------------+-----------------+-----+---------------+-----------------+---------------------+------------+------------+--------------+
| Master_Host | Master_User | Master_Port | Connect_retry |
Log_File | Pos | Slave_Running | Replicate_do_db |
Replicate_ignore_db | Last_errno | Last_error | Skip_counter |
+-------------+-------------+-------------+---------------+-----------------+-----+---------------+-----------------+---------------------+------------+------------+--------------+
| sumatra | blah | 3306 | 60 |
sumatra-bin.014 | 73 | Yes | |
news | 0 | | 0
|
+-------------+-------------+-------------+---------------+-----------------+-----+---------------+-----------------+---------------------+------------+------------+--------------+
1 row in set (0.00 sec)
which each time has the same position number (on Master and SLave), when
i enter the above statement
I don't find something about souch a Problem in the manual.
I use mysql Version 3.23.36 on Sun Solaris 2.6
Master configuration :
log-bin
server-id = 1
binlog-ignore-db = news
Slave confguration:
master-host=sumatra
master-user=blah
master-password=blah
master-port=3306
server-id=2
Thank for your help
Dani
------------------------------------------------------------
Daniel Tschanz Phone: +41 32 344 86 00
Rolotec AG Direct: +41 32 344 86 42
Gottstattstrasse 24, Postfach 8 Fax: +41 32 344 86 86
2500 Biel 8 mailto: [EMAIL PROTECTED]
------------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php