Hi Mike,
It is not enough to just have binlog files on your slave. The binlog is
just storing what is being executed on the slave, so if that is all
you have, then replication is not working.
You also need master.info, relay-log.info, and relay log files.
To start replication you need to execute the following commands:
CHANGE MASTER TO
MASTER_HOST='master_host_name',
MASTER_USER='replication_user_name',
MASTER_PASSWORD='replication_password',
MASTER_LOG_FILE='recorded_log_file_name',
MASTER_LOG_POS=recorded_log_position;
START SLAVE;
The best place to read about this, is here:
http://dev.mysql.com/doc/mysql/en/replication-howto.html
Best wishes,
Lars
On Fri, Jan 21, 2005 at 04:19:15PM -0600, Mike Klein wrote:
> I have set up a master and slave on 2 different machines. Both have the
> bin files, so I think it's working. However, when I update the database
> on the master, the slave doesn't reflect the change! Is there
> something else I need to do? The master is aix 3.23.33 and the slave is
> 4.1.9.
>
> Thanks
>
> Mike Klein
> Manager of System Services
> Loyola University New Orleans
> 6363 St. Charles Ave.
> New Orleans, LA 70118
> (504) 865-3470
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: http://lists.mysql.com/replication?unsub=1
--
Dr. Lars Thalmann
MySQL AB, www.mysql.com
