日期:2014-05-16  浏览次数:20775 次

mysql数据同步问题
server-id=2
master-host=192.168.1.200
master-user=slave1
master-password=123456
master-port=3333
master-connect-retry=60
replicate-do-db=zoutuo


这个是我slave端my.ini的配置,现在这样配置后服务器不来,报错:

111225 22:23:40 [Note] Plugin 'FEDERATED' is disabled.
111225 22:23:40 InnoDB: The InnoDB memory heap is disabled
111225 22:23:40 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111225 22:23:40 InnoDB: Compressed tables use zlib 1.2.3
111225 22:23:40 InnoDB: Initializing buffer pool, size = 55.0M
111225 22:23:40 InnoDB: Completed initialization of buffer pool
111225 22:23:40 InnoDB: highest supported file format is Barracuda.
111225 22:23:40 InnoDB: Waiting for the background threads to start
111225 22:23:41 InnoDB: 1.1.8 started; log sequence number 1595675
111225 22:23:41 [ERROR] MySQL: unknown variable 'master-host=192.168.1.200'
111225 22:23:41 [ERROR] Aborting

111225 22:23:41 InnoDB: Starting shutdown...
111225 22:23:41 InnoDB: Shutdown completed; log sequence number 1595675
111225 22:23:41 [Note] MySQL: Shutdown complete

它提示错误的变量“master-host=192.168.1.200”。这是为什么呢?

------解决方案--------------------
master-host这个参数已经废弃了


你需要用change master to master_host='ss',master_user='aa',master_password='sss',master_log_file='ss',master_log_pos=4;来设置slave
------解决方案--------------------
http://www.mike.org.cn/articles/mysql-master-slave-sync-conf-detail/
可以参考一下这篇文章,说的很详细
------解决方案--------------------
你主从机的MySQL版本分别是多少?从机MySQL版本不能低于主机的MySQL版本的。