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]