LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 05-11-2012, 07:24 AM   #1
nandunay
LQ Newbie
 
Registered: Oct 2011
Posts: 9
Blog Entries: 4

Rep: Reputation: Disabled
I m not able to start slave server..


These cmd on slave server side..... i m not able to start slave server....
master: 192.168.10.1
slave: 192.168.10.30

mysql> CHANGE MASTER TO MASTER_HOST='192.168.10.1', MASTER_USER='slave-user', MASTER_PASSWORD='password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=0;

query ok,..............


mysql> START SLAVE;

ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO

Note:
SLAVE_IO_Running: NO
SLAVE_SQL_Running: NO

Last edited by nandunay; 05-11-2012 at 07:25 AM.
 
Old 05-11-2012, 10:05 AM   #2
TenTenths
Senior Member
 
Registered: Aug 2011
Location: Dublin
Distribution: Centos 5 / 6 / 7
Posts: 2,756

Rep: Reputation: 1063Reputation: 1063Reputation: 1063Reputation: 1063Reputation: 1063Reputation: 1063Reputation: 1063Reputation: 1063
Please provide the sections of your my.cnf where you've set up the server as a slave.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Slave - Log queries including those executed on Slave Replay helptonewbie Linux - Server 0 04-11-2012 07:17 AM
[SOLVED] Could not start process Unable to create io-slave:klauncher said:Error loading kio-de yancek Linux - Software 1 08-09-2011 07:53 PM
dns slave server sunlinux Linux - Server 3 03-12-2011 03:38 PM
MySQL Master-Slave Replication - How to make the slave read-only? saagar Linux - Server 1 08-31-2010 09:13 AM
Slave server config MidWest Linux - Networking 3 10-19-2002 06:45 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 11:14 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration