Chris Mason wrote:
I have two servers, server5.mydomain.com and server8.mydomain.com. I want to replicate one database on server5 to server 8. I did the whole proceedure as recommended in http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set Up Replication
I setup the GRANT statement on server5 for the slave.
mysql> SHOW GRANTS FOR [EMAIL PROTECTED]; +--------------------------------------------------------------------------- -------------------------------------------+ | Grants for [EMAIL PROTECTED] | +--------------------------------------------------------------------------- -------------------------------------------+ | GRANT RELOAD, SUPER, REPLICATION SLAVE ON *.* TO 'server8'@'MyServer8IP' IDENTIFIED BY PASSWORD 'xxxxxxx' | +--------------------------------------------------------------------------- -------------------------------------------+ 1 row in set (0.00 sec)
But when I stop and start the slave, I get:
050316 8:56:42 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000004' at position 79, relay log './server8-relay-bin.000001' position: 4 050316 8:56:42 [ERROR] Slave I/O thread: error connecting to master '[EMAIL PROTECTED]:3306': Error: 'Unknown MySQL server host 'server5.picado.com' (1)' errno: 2005 retry-time: 60 retries: 86400
When I try from the command line, I get it to work without problem:
[EMAIL PROTECTED] mysql]# mysql -h server5.domain.com -u server8 -pxxxxxxxx Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 30 to server version: 4.1.10-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
You have master set to server5.picado.com, not server5.domain.com.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
