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]