Mysql binlog恢复数据

mysqldump -uroot -pyangxxxx test > ./test.sql

-- service mysqld restart
    
-- show master status; 
    
-- show binlog events in "mysql-bin.000060"; 
    
-- 开始位置120，修改数据; 修改后结束位置 800 

--  删除数据

  -- mysql -uroot -pyang156122
    
-- use test 
    
-- source ./test.sql 

   --  service mysqld restart
 
   -- show master status; 

  -- /usr/bin/mysqlbinlog  --start-position=120 --stop-position=800 --database=test  /var/lib/mysql/mysql-bin.000060 | /usr/bin/mysql -uroot -pyang156122 -v test