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