title: how to get mysql server to stop starting as slave
body: <p>I have a an ubuntu we server running mysql 5.1.  Previously I had this server set up as a slave for replication.  Now I and switching rolls for this server and I do not need it to be a slave anymore.  <strong>The problem is</strong> that right now, every time the mysql is restarted, it starts into slave mode, and when I run commands like this:</p>
  
  <pre><code>mysql &lt; mysql_dump_file.sql
  </code></pre>
  
  <p>I get this error:</p>
  
  <pre><code>ERROR 1198 (HY000) at line 22: This operation cannot be performed with a running slave; run STOP SLAVE first
  </code></pre>
  
  <p>Of course I can run the <code>stop slave;</code> command in mysql and it fixes the issue, but when I restart the server the problem comes back.  </p>
  
  <p>Previously for the slave configuration, I had added the following lines in the my.cnf file:</p>
  
  <pre><code>port=3306
  log-bin
  server-id=2
  master-host=(ip of master)
  master-user=repl
  master-password=slavepass
  master-port=3306
  replicate_do_db=(db to replicate)
  </code></pre>
  
  <p>Now I have removed all these lines and restarted, and the db automatically starts into slave mode still.  I am trying to configure the mysql so that it will NOT start up in slave mode.  What am I missing?  </p>
  
  <p>Thanks!</p>