- 论坛徽章:
- 1
|
然后,再继续分析binlog日志:
mysqlbinlog --base64-output=decode-rows -v ./mysql-bin.000003 \
| grep -e "^##* UPDATE" -e "^##* INSERT" -e "^##* DELETE" -e "^##* \
REPLACE" -i -e "^update" -e "^insert" -e "^delete" -e "^replace"| \
awk -F ' ' ' { print $1,$2,$3,$4}' | sed 's/^##*//g' | tr '[A-Z]' '[a-z]' \
| awk -F ' ' ' { if($1=="update") {$3=""} print $1,$2,$3}' \
| sed -e "s/\t/ /g;s/\`//g;s/(.*$//;s/[a-zA-Z0-9\_\-]*\.//;s/ set .*$//;s/ as .*$//" \
insert into user
insert into user
insert into user
insert into user
insert into user
insert into user
update user
delete from user
(把前面的zsd.都祛除了) |
|