problem with master slave

Discussion in 'HOWTO-Related Questions' started by nephish, May 1, 2007.

  1. nephish

    nephish New Member

    hello there,
    great tutorial on the mysql replication master slave thing.

    i got almost all the way through it and hit an error at the SLAVE START;
    part.

    the terminal spit this out.

    Code:
    mysql> START SLAVE;
    ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO
    any idea what i should look at ?

    thanks
     
  2. falko

    falko Super Moderator Howtoforge Staff

  3. nephish

    nephish New Member

    yes, this is the one i had the problem with, i have since found the problem though.
    i run mysql on startup with /etc/init.d/mysql start.
    so the lines in the my.cnf file that the tutorial listed needed to be under the
    [mysqld] portion of the file.
    when i did that, it worked.
    thanks for your help
     

Share This Page