Error 1200 <hy000>:

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • ram09
    New Member
    • Oct 2008
    • 45
    #1

    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^^
    Tags: None
    • ram09
      New Member
      • Oct 2008
      • 45
      #2
      ERROR 1200&lt;HY000&g t;: The server is not configured as slave;????

      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....ERRO R 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

        Comment

        • ram09
          New Member
          • Oct 2008
          • 45
          #3
          Problem With Master Slave Replication

          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...everyt ime 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

            Comment

            • Atli
              Recognized Expert Expert
              • Nov 2006
              • 5062
              #4
              ram09.

              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.
              Moderator

                Comment

                Previous template Next
                Working...