centos7下基于binlog恢复数据

     centos7下基于binlog恢复数据          前提：已开启binlog,开启方式看这里准备工作mysqlbinlog：其在mysql的目录下mysql-bin.00000？文件：一般会在mysql的data目录下，入我的就是在/usr/local/mysql/data下。mysqlbinlog使用（也可以把文件下载到本地进行操作）转为sql文件（不可直接执行的sql脚本）./mysqlbinlog--no-defaults--database=tobacco--base64-output=decode-rows-v/usr/local/mysql/data/mysql-bin.000001>/home/mysql-bin01.sql恢复数据./mysqlbinlog--no-defaults--database=tobacco/usr/local/mysql/data/mysql-bin.000004|mysql-uroot-proot-vtobacco其它参数说明参数说明–start-datetime开始时间–stop-datetime结束时间more直接查看示例./mysqlbinlog--no-defaults--database=tobacco--start-datetime="2021-11-2611:55:20"--stop-datetime="2021-11-2611:55:23"/usr/local/mysql/data/mysql-bin.000004|mysql-uroot-proot-vtobacco./mysqlbinlog--no-defaults--database=tobacco--start-datetime="2021-11-2611:55:20"--stop-datetime="2021-11-2611:55:23"/usr/local/mysql/data/mysql-bin.000004|mmore -全文完-