mysql数据恢复

 第一步：

./mysqlbinlog --no-defaults --database=shopeebao1688 --start-datetime="2020-07-01 00:00:00" --stop-datetime="2020-08-11 10:26:00" /www/server/data/mysql-bin.000012    > snake_pack.txt

第二步：

./mysqlbinlog --no-defaults --database=shopeebao1688 --start-datetime="2020-07-10 00:00:00" --stop-datetime="2020-08-11 10:26:00" /www/server/data/mysql-bin.000012   | grep snake_pack   > snake_pack_log.txt

筛选指定表的指定操作语句：例如下面是筛选 UPDATE 语句

./mysqlbinlog --no-defaults --database=shopeebao1688 --start-datetime="2021-07-14 11:58:35" --stop-datetime="2021-07-24 12:18:00" /www/server/data/mysql-bin.000074 | grep -i -E '^update' | grep snake_goods  > snake_goods_log.txt

正则匹配指定sql的记录 

 ./mysqlbinlog --no-defaults --database=1688vipcomcn --start-datetime="2023-01-01 00:00:00" --stop-datetime="2023-08-08 17:30:00" /www/server/data/mysql-bin.000102 | grep -i -E '^UPDATE `snake_goods`  SET `is_sign`=0,`express_number`' | grep snake_goods  > snake_goods_log_update.txt