数据库log恢复

mysqlbinlog mysql-bin.000141 -d data_dev_platform --skip-gtids --stop-position=979149463>test3.sql ‘data_dev_platform’

mysqlbinlog --stop-position=979149463 --database=data_dev_platform mysql-bin.000141>test5.sql

mysqlbinlog –no-defaults –stop-datetime=‘2020-09-12 11:15:24’ mysql-bin.00014 >test6.sql

mysqlbinlog --no-defaults -d data_dev_platform --start-datetime=‘2018-09-11 8:54:40’ --stop-datetime=‘2018-09-11 12:59:10’ mysql-bin.000032 >temp20180911.sql

mysqlbinlog --base64-output=decode-rows -v --database=data_dev_platform --start-datetime=‘2020-08-11 10:48:53’ --stop-datetime=‘2020-09-12 11:15:24’ mysql-bin.000141 >888.sql

mysqlbinlog --base64-output=decode-rows -v --database=data_dev_platform --start-datetime=‘11:19:30’ --stop-datetime=‘2020-09-12 11:19:54’ mysql-bin.000141

mysqlbinlog–stop-datetime=“2018-02-19 23:57:02” mysql-bin.000088 | mysql

mysqlbinlog --database=data_dev_platform --start-datetime=‘2020-08-11 10:48:53’ --stop-datetime=‘2020-09-12 11:15:24’ mysql-bin.000141 | mysql -uroot -pUP@PZf2xAyCcQ1H9xIo7M -v data_dev_platform;