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

posted @ 2023-11-24 14:44  zda龙  阅读(22)  评论(0)    收藏  举报