格式化输出
mysqlbinlog --base64-output=decode-rows -v --database=sunshinezhenda --start-datetime="2023-07-21-10 08:47:00" --stop-datetime="2023-11-10 08:00:00" /var/lib/mysql/mysql-bin.000014 > tmp.sql
根据时间节点恢复
mysqlbinlog --start-datetime="2023-07-28 08:00:20" --stop-datetime="2023-11-10 08:00:00" --database=sunshinezhenda /var/lib/mysql/mysql-bin.000014 | mysql -uroot -pcxjSAvjIwL%x0fGD -v sunshinezhenda;
根据起始位置恢复
mysqlbinlog --start-position=630399310 --stop-position=654641954 --database=sunshinezhenda /var/lib/mysql/mysql-bin.000014 | mysql -uroot -pcxjSAvjIwL%x0fGD -v sunshinezhenda;
输出base解码后的sql
mysqlbinlog --base64-output=decode-rows -vv --start-datetime='2023-10-25 00:00:00' --stop-datetime='2023-10-25 17:00:00' /var/lib/mysql/mysql-bin.000014 > /tmp/sql_record.txt