Solution: MySQL Master-Master Replication Fails With ERROR 1200 (HY000) on Master ��������� MySQL����������ʧ�ܣ�����1200 �� hy000 �� ��˶ʿ
When you try MySQL master-master replication with two (or more) servers you may often find that in the process of configuring the original master to also act as a slave server (start slave), it fails with the following error:������MySQL���������������������������ϣ�������������ܾ������֣��������������õ�ԭ���ˣ�Ҳ�䵱ū������������ʼū���� ������������Ĵ���
mysql> start slave; MySQL��>��ʼ��ū��;
ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO ����1200 �� hy000 �� ��������δ����Ϊū��; FIX��config�ļ��У�����仯����
To rectify it locate and delete the master.info file and restart the mysql server.Ҫ�������ҵ���ɾ��master.info�ļ�����������MySQL�������� Now try to start slave and it should work.���ڳ�������ū������Ӧ������ In short on my machine I did:�ڶ����ڶ��ҵĻ����ң�
rm /var/lib/mysql/master.info �ҵ�/ var / lib / MySQL��/ master.info
Filed under������ Database��ݿ� , �� Database Replication��ݿ⸴�� , �� Enterprise Software��ҵ��� , �� Headline Newsͷ������ , �� How To��� , �� Linux Linux�� , �� MySQL MySQL�� , �� Open Source Software����Դ����� , �� RDBMS RDBMS�� | |
| |
RSS 2.0 2.0 | |
Trackback Trackback���� this Article |������|
Email this Article�����ʼ�������
You may also like to read��Ҳ������� |



































