#1  
Old 1st May 2007, 23:19
nephish nephish is offline
Junior Member
 
Join Date: May 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default problem with master slave

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
Reply With Quote
Sponsored Links
  #2  
Old 2nd May 2007, 15:11
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Did you take a look at this tutorial? http://www.howtoforge.com/mysql_database_replication
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 2nd May 2007, 15:23
nephish nephish is offline
Junior Member
 
Join Date: May 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
BIND as a slave for MyDNS master MooktaKiNG General 26 3rd July 2010 22:55
sending e-mail using mail() function linuxuser1 HOWTO-Related Questions 38 21st April 2009 12:20
Slave DNS problem dlikar Installation/Configuration 6 14th June 2007 21:39
SuSE as master DNS server and Centos as slave DNS server... sthompson Server Operation 3 17th September 2006 13:24
Problem with slave DNS DarkBen Installation/Configuration 15 5th January 2006 12:42


All times are GMT +2. The time now is 14:45.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.