that would make both Slave_IO_Running: Yes Slave_SQL_Running: Yes go to "No" i only want to stop the Slave_SQL_Running and keep the Slave_IO running so my show slave status would report the following: Slave_IO_Running: Yes Slave_SQL_Running: No it happens if the mysql recives an update and failes during the update. ive tried reading the documentation about mysql replication, but i cannot find what i am looking for.
________________________________ Fra: sheeri kritzer [mailto:[EMAIL PROTECTED] Sendt: on 25-01-2006 22:56 Til: Morten Kallesøe Cc: mysql@lists.mysql.com Emne: Re: replication SLAVE STOP; or STOP SLAVE; work equally well. Or am I not understanding your question correctly? -Sheeri On 1/25/06, Morten Kallesøe <[EMAIL PROTECTED]> wrote: > Hi > > on a slave, is it possible to only stop the SQL Thread? (Slave_SQL_Running: > Yes/No) > > > i need to do some testing with my script and i got to make sure it reads that > value correctly. > > regards > Morten > >