mysql主从复制的遇到的一些错误

1.Misconfigured master – server id was not set
可能是mysql的bug,在my.cnf中修改server-id=10,而不是之前写的1.
2. Last_IO_Errno: 1045 Last_IO_Error: error connecting to master’replication@10.24.54.18:3306′ – retry-time: 60 retries: 86400
主库开启了防火墙,添加过滤规则,或者关闭防火墙
3.Slave SQL: Error ‘Table ‘xxxx’ doesn’t exist’ on query. Default database: ‘t591’. Query: ‘INSERT INTO xxxx(type,post_id,browsenum) SELECT type,post_id,browsenum FROM xxxx WHERE hitdate=’20090209”, Error_code: 1146
是同步时,没有找到对应的库或者表,添加对应的表就行.

---

参考:
http://blog.csdn.net/u011698346/article/details/37934505