CODEWITHSUNDEEP
mysqldatabase-replication
Nitsan Baleli
Nitsan Baleli

Reputation: 5458

start mysql with --skip-slave-start

I need to start mysql server with '--skip-slave-start' option, as stated in tutorials/docs.

How can I achive that?

trying the next commands does not work: 

service mysql start --skip-slave-start

start: invalid option: --skip-slave-start

mysql>SLAVE START --skip-slave-start;

ERROR 1064 (42000): You have an error in your SQL syntax;

Upvotes: 3

Views: 25952

Answers (2)

David
David

Reputation: 875

sudo mysqld_safe --skip-slave-start

Upvotes: 2

fancyPants
fancyPants

Reputation: 51878

You're getting a syntax error with this:

mysql>SLAVE START --skip-slave-start;

because that's not a valid statement.

This here

service mysql start --skip-slave-start

invokes another script calling mysqld. Either you adjust the script, or easiest would be you put the option in your config file (most probably under /etc/my.conf

like this

[mysqld]
skip-slave-start

Upvotes: 13

Related Questions