MySQL Forums
Forum List  »  Replication

Re: error 1201:change master to ... master.info.empty
Posted by: Francesco Marceca
Date: December 29, 2009 11:11AM

Thanks for your answer, here the contents of my.ini files on server and slave (only replication section!)

the server one
#-------------------
server-id=10
log-bin=c:\mysql-bin.log
binlog-do-db=replica
max_bin_log_size=104857600
show-slave-auth-info
#-------------------

and the slave one
#-------------------
server-id=20
log-bin=slave-bin.log
master-host=192.168.1.10
master-user=root
master-password=my-pass
master-connect-retry=60
replicate-do-db=replica
#---------------------

when i start the slave server in the .err it write
091229 17:53:50 [Note] Plugin 'FEDERATED' is disabled.
091229 17:53:51 InnoDB: Started; log sequence number 1 3122214161
091229 17:53:51 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=nb-epi-relay-bin' to avoid this problem.
091229 17:53:51 [ERROR] Error reading slave log configuration
091229 17:53:52 [ERROR] Failed to initialize the master info structure
091229 17:53:52 [Note] Event Scheduler: Loaded 0 events
091229 17:53:52 [Note] D:\Programmi\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.38-community-log' socket: '' port: 3306 MySQL Community Server (GPL)

and that's all.
Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: error 1201:change master to ... master.info.empty
2991
December 29, 2009 11:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.