Hello, I'm trying to get replication working between two MySQL servers.
I'm running MySQL 3.23.43-log on a Solaris Server and MySQL 3.23.43-nt on a Win2k Server. I am trying to set up the Solaris Server as a slave and the Win2k Server as the master. Following the replication instructions on http://www.mysql.com/doc (4.10.3), I have done the following: 1) Created a replication user on the master with FILE privilege. 2) Shutdown the master (with mysqladmin -u root -p shutdown AND net stop mysql). 3) zipped up \mysql\data 4) Added the following to my.cnf (on the master): [mysqld] log-bin server-id=1 5) Restarted the master (with mysqladmin -u root -p start AND net start mysql). 6) Shutdown the slave (with mysql.server stop). 7) Copied my-medium.cnf to /etc/my.cnf 8) Added the following to my.cnf (on the slave): [mysqld] master-host=win2k master-user=replicationuser master-password=replicationuser-password master-port=3306 server-id=2 9) unzipped \mysql\data to /usr/local/mysql/data (and overwrote the mysql directory). 10) Restarted the slave. I am receiving the following error messages in my server.err files: Slave.err 011102 16:47:51 Slave: Failed reading log event, reconnecting to retry, log 'win2k-bin.002' position 32 011102 16:47:51 Slave: reconnected to master 'replicationuser@win2k:3306',replication resumed in log 'win2k-bin.002' at position 32 011102 16:47:51 Slave: received 0 length packet from server, apparent master shutdown: (0) Master.err 011102 16:45:57 Slave thread: error connecting to master: Can't connect to MySQL server on '' (10049) (0), retry in 60 sec 011102 16:47:09 Slave thread: error connecting to master: Can't connect to MySQL server on '' (10049) (0), retry in 60 sec 011102 16:48:21 Slave thread: error connecting to master: Can't connect to MySQL server on '' (10049) (0), retry in 60 sec Does anyone have any idea about what I could have done wrong? Thanks for your help! --Steve Morad --------------------------------------------------------------------- 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
