<span style= "FONT-SIZE:18PX;" >******* ********show slave status shows slave_sql_runing as no, seconds_behind_master is NULL because the database cannot be synchronized : A: The program may have written on slave B: It may also be the solution of a rollback of a slave machine after a reboot: slave stop; set GLOBAL sql_slave_skip_counter=1; Set a global parameter slave start; solution two: (1): Salve (from) library, slave stop; --Stop the Slave service Master (Master) library, show master status, get &a log dissemble &b location--Get the current binary log and offset on the primary server (2): Salve Library: View status, can perform manual synchronization on the salve server--man-made operation change Master to master_host= "192.168.101.1", master_uset= "user1", master_password= " pass123456 ", master_port=3306,master_log_file=" mysql-bin.00003 ", step (1) Check out the &a log file name master_log_pos=98; Step (1) Check out the &b position--can be manually synchronized after (3) Start Salve Service salve start; (4) View salve_sql_runing as Yes,seconds_behind_ via show salve status Master is 0 for normal </span>
MySQL does not have a master-slave copy Solution