数据库数据及表恢复

mysqlbinlog --no-defaults --database=hesc_stm_jinhua --start-datetime="2020-06-05 12:00:00" --stop-datetime="2020-06-05 20:00:00" /opt/mysqldata/master-bin.000046 > 999.sql
254 mysqlbinlog --no-defaults --database=hesc_stm_jinhua --start-datetime="2020-06-05 12:00:00" --stop-datetime="2020-06-05 20:00:00" /opt/mysqldata/master-bin.000046 > /opt/999.sql
269 whereis mysqlbinlog
272 mysqlbinlog --no-defaults --database=youxi --start-datetime="2020-06-05 00:00:00" --stop-datetime="2020-06-05 22:00:00" /opt/mysqldata/master-bin.000045 > /opt/12222.txt
273 mysqlbinlog --no-defaults --database=youxi --start-datetime="2020-06-05 00:00:00" --stop-datetime="2020-06-05 22:00:00" /opt/mysqldata/master-bin.000046 > /opt/55555.txt
274 mysqlbinlog --no-defaults --database=hesc_stm_jinhua --start-datetime="2020-06-05 00:00:00" --stop-datetime="2020-06-05 22:00:00" /opt/mysqldata/master-bin.000045 > /opt/666.txt
276 whereis mysqlbinlog
278 mysqlbinlog --no-defaults --database=hesc_stm_jinhua --start-datetime="2020-06-05 00:00:30" --stop-datetime="2020-06-05 15:00:00" /opt/mysqldata/master-bin.000046 > /opt/hesc_stm_jinhu_hf.sql
284 whereis mysqlbinlog
286 /usr/bin/mysqlbinlog --no-defaults /opt/mysqldata/master-bin.000046 > mysql_bak.sql
299 /usr/bin/mysqlbinlog --database=hesc_stm_jinhua --no-defaults -v --base64-output=decode-rows -vv /opt/mysqldata/master-bin.000046 > mysql_bak.sql
300 /usr/bin/mysqlbinlog --database=hesc_stm_jinhua -v --base64-output=decode-rows -vv /opt/mysqldata/master-bin.000046 > mysql_bak.sql
301 /usr/bin/mysqlbinlog --no-defaults--no-defaults --database=hesc_stm_jinhua -v --base64-output=decode-rows -vv /opt/mysqldata/master-bin.000046 > mysql_bak.sql
302 /usr/bin/mysqlbinlog --no-defaults --database=hesc_stm_jinhua -v --base64-output=decode-rows -vv /opt/mysqldata/master-bin.000046 > mysql_bak.sql
315 whereis mysqlbinlog
317 mysqlbinlog --no-defaults --database=hesc_stm_jinhua --start-datetime="2020-06-05 00:14:00" --stop-datetime="2020-06-05 20:00:00" /opt/mysqldata/master-bin.000056 > /opt/hesc.sql
318 mysqlbinlog --start-position=209686044 --stop-position=235436178 --database=hesc_stm_jinhua /opt/mysqldata/master-bin.000056 | /usr/bin/mysql -uroot -p123456 -v hesc_stm_jinhua
319 mysqlbinlog --start-position=209686044 --stop-position=235436178 --database=hesc_stm_jinhua /opt/mysqldata/master-bin.000056 | /usr/bin/mysql -uroot -p -v hesc_stm_jinhua
320 mysqlbinlog --start-position=209686044 --stop-position=235436178 --database=hesc_stm_jinhua /opt/mysqldata/master-bin.000056 | /usr/bin/mysql -uroot -p123456 -v hesc_stm_jinhua
322 mysqlbinlog --start-position=235440843 --stop-position=245979811 --database=hesc_stm_jinhua /opt/mysqldata/master-bin.000056 | /usr/bin/mysql -uroot -p123456 -v hesc_stm_jinhua
323 mysqlbinlog --no-defaults --start-position=235440843 --stop-position=245979811 --database=hesc_stm_jinhua /opt/mysqldata/master-bin.000056 | /usr/bin/mysql -uroot -p123456 -v hesc_stm_jinhua