Hi All,
Sorry if I'm missing something totally daft here...
I've got my master and slave hosts (both runng MySQL 3.23.36) configured
roughly as-per the HOWTO, ( as follows ) to replicate the "test"
database, but not the "mysql" database [btw. it's not clear from the
docs that if you omit both binlog-ignore-db and binlog-do-db whether
all, or none of the databases are replicated.. what is the actual case
there? ]
Now, I'm not sure I've got the 'master-port' setting on the slave right,
infact I think it's wrong, because that's the client connection port,
but netstat or the docs wouldn't tell me a more likely port number, so I
guessed. (is that the wrong port?).
So either I have the wrong port, or there's a bug, because (and nothing
appears in the .err file on the slave or master about this) when I do a
"SLAVE START" on the slave, it goes:
"mysql> slave start;
ERROR 1200: The server is not configured as slave, fix in config file
or with CHANGE MASTER TO"
... even when I've configured the slave just as it suggests...
So, could someone please let me know if I'm being stupid, or if it's
MySQL that's at fault here?
Thanks in advance.
Yours,
Kev.
Master:
cat /etc/my.cnf
[mysqld]
log-bin=/var/lib/mysql/replication
server-id=2
binlog-do-db=test
binlog-ignore-db=mysql
mysql> show full processlist;
+-----+----------+-----------+----------+---------+------+-------+--------------
---------+
| Id | User | Host | db | Command | Time | State | Info
|
+-----+----------+-----------+----------+---------+------+-------+--------------
---------+
| 117 | sendmail | localhost | sendmail | Sleep | 28 | | NULL
|
| 118 | sendmail | localhost | sendmail | Sleep | 28 | | NULL
|
| 121 | sendmail | localhost | sendmail | Sleep | 28 | | NULL
|
| 127 | root | localhost | NULL | Query | 0 | NULL | show
full pro
cesslist |
+-----+----------+-----------+----------+---------+------+-------+--------------
---------+
4 rows in set (0.00 sec)
mysql> show master status;
+-----------------+----------+--------------+------------------+
| File | Position | Binlog_do_db | Binlog_ignore_db |
+-----------------+----------+--------------+------------------+
| replication.002 | 147 | test,test | mysql,mysql |
+-----------------+----------+--------------+------------------+
1 row in set (0.00 sec)
mysql> exit
Bye
Slave:
[mysql]
server-id=4
master-host=lestat.ore.org
master-user=replicate
master-password=splitter
log-slave-updates=/var/lib/mysql/slave-updates.log
master-port=3306
mysql> show full processlist;
+----+------+-----------+------+---------+------+-------+-----------------------
+
| Id | User | Host | db | Command | Time | State | Info
|
+----+------+-----------+------+---------+------+-------+-----------------------
+
| 1 | root | localhost | test | Query | 0 | NULL | show full
processlist
|
+----+------+-----------+------+---------+------+-------+-----------------------
+
1 row in set (0.00 sec)
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 |
+----------------+-------------+-------------+---------------+-----------------+
-----+---------------+-----------------+---------------------+------------+-----
-------+--------------+
| lestat.ore.org | replicate | 3306 | 60 |
replication.002 |
73 | No | | |
0 |
| 0 |
+----------------+-------------+-------------+---------------+-----------------+
-----+---------------+-----------------+---------------------+------------+-----
-------+--------------+
1 row in set (0.00 sec)
mysql>
--
"Life is the sieve through which my anarchy strains, resolving itself
into words"
Kev Green, aka. Kyrian www.ore.org -- Bad
Religion
---------------------------------------------------------------------
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
