472,127 Members | 1,445 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.

Error 1200 <hy000>:

ERROR 1200 <HY000>: The sever is not configured as slave; fix in config file or with CHANGE MASTER TO... i always encounter this error whenever i start slave...i already reset my master and slave..i also checked the my.ini file...they both have a server id already...but its still the same...can anyone help me with this please...tnx^^
Oct 28 '08 #1
3 5208
I tried making a slave database in another server, i did all the necessary configurations such as putting a unique server-id in both the master server and the slave server... I am also done with the replication of the database using the mysqldump and it already worked with my slave server.... after that, i configured the slave server using the CHANGE MASTER TO option...i filled up all the needed details like the master_log_file and master_log_pos etc..... but when i start the slave server using the START SLAVE option, an error message occured....ERROR 1200<HY000>: The server is not configured as slave; fix in config file or with CHANGE MASTER TO.....I tried it a couple of times but it always has an error when it comes to this part....can somebody help me with this please????i am really confused because i fallowed all the necessary steps in database replication but it still didnt work...somebody help me please...tnx
Oct 29 '08 #2
i was setting up a master database and a slave database, both in different servers...i dont know what really is the problem because i did all the necessary steps in making a slave database....all was fine...but after i did all the steps, there is still a problem...my slave server cannot connect with the master...once in a while i check the slave server by using the SHOW SLAVE STATUS option...everytime the output was just the same, the slave_io_state is always connecting to the master....i really dont know what else is the problem with this one...can somebody help me with this please..i really need to solve this problem...T_T
Oct 30 '08 #3
5,058 Expert 4TB

Do NOT double post your questions.
This only serves to cause confusion and to annoy the moderators!

I have merged your 3 threads on this topic into this one thread.

We do our best to respond to all questions as soon as we can but occasionally it may take us a little longer than usual. If you feel that your question has been overlooked (which is rarely that case, I assure you), then feel free to *bump* your thread back up to the top, but do not re-post it in another thread. Having to straighten out the mess does not help our response times!

There is an entire section devoted to this subject in the Posting Guidelines, which we expect that you read before posting here.

Thank you.
Oct 30 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by neutrinman | last post: by
reply views Thread by Don Stevic | last post: by
9 posts views Thread by Mairhtin O'Feannag | last post: by
4 posts views Thread by james margey | last post: by
12 posts views Thread by user923005 | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.