Sorry, I hit send before I was actually done. So.... Given the error I am getting:

070131 11:53:55 [ERROR] Slave I/O thread: error connecting to master '[EMAIL PROTECTED]:3306': Error: 'Can't connect to MySQL server on 'Anchorman' (10061)' errno: 2003 retry-time: 60 retries: 86400

There are a couple of issues hwere. Primary is that it's trying to connect on port 3306. I'm actually using 3307, but can't seem to find where I change this setting. Have any suggestions?

Thanks,
Jesse

----- Original Message ----- From: "Michael DePhillips" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>
Cc: "MySQL List" <mysql@lists.mysql.com>
Sent: Tuesday, January 30, 2007 7:57 PM
Subject: Re: Replication not working?


Should be almost instantaneous. Do a show slave status on the slave....also check the error log.

Jesse wrote:

I'm playing with setting up replication on two MySQL Servers that I have set up here. I set it up according to the instructions found on the MySQL web site, then I went in on the master and added a new record to one of the tables, then checked the slave about 30 minutes later, and the record has not appeared. How often does the slave check for new records on the master? Also, is there some location that I can check for errors?

Thanks,
Jesse





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to