mysql binlog 恢复数据
grep "insert into rpt_cash set StoreID='07'" mnt/data/mariadb_tmp/7.sql > mnt/data/mariadb_tmp/9.sql
/usr/local/mariadb/bin/mysqlbinlog --start-datetime='2023-11-07 15:00:00' /mnt/data/mariadb_tmp/mysql-bin.000007 | mysql -h 数据库IP -P 3306 -u root -p

浙公网安备 33010602011771号