"Crawling out of the pit" MySQL slave to master

First, view the log app status

mysql> show processlist;+----+------+---------------+-------+-------------+------+--------------- --------------------------------------------------------+------------------+-----------+---------------+|  Id | user | host          | db     | Command     | Time | State                                                                     | Info              | rows_sent | rows_examined |+----+------+------------ ---+-------+-------------+------+-----------------------------------------------------------------------+------------------+----------- +---------------+|  5 | root | localhost     |  ifree | sleep       | 2250 |                                                                           | NULL              |          0 |             0 | |  17 | rep &nbsP;| testdb2:41690 | null  | binlog dump | 2400 | master  has sent all binlog to slave; waiting for binlog to be  updated | null             |          0 |              0 | |  19 | root | localhost     | NULL  |  query       |    0 | init                                                                     | show processlist |          0 |              0 |+----+------+---------------+-------+-------------+------+-------------- ---------------------------------------------------------+------------------+-----------+---------------+3  rows in set  (0.00 SEC)

(In fact, I do not understand ...) ）

Second, modify the/ETC/MY.CNF (refer to master configuration, here Apprenticeship Father Blog, slightly)

http://debugo.com/mysql-5-6-master-slave/

Three, stop slave, turn off read-only

1. Stop slave

mysql> stop Slave; Query OK, 0 rows affected, 1 Warning (0.00 sec)

2. Off-Read Only

mysql> set global read_only=0; Query OK, 0 rows Affected (0.00 sec)

3. Reset Slave

mysql> Reset Slave; Query OK, 0 rows affected (0.01 sec)

Iv. Restart the MySQL process if it is not in effect try

Reference: http://blog.itpub.net/758322/viewspace-714346

Crawl out of the pit MySQL slave to master