master Server
show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000177 | 31692464 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.000 sec)
File = mysql-bin.000177, Position = 31692464
slave Server
stop slave;
CHANGE MASTER TO master_log_file = 'mysql-bin.000177', master_log_pos =31692464;
start slave;
show slave status \G;