mysql binlog恢复到:2023-02-23 00:00:00 至 2023-04-05 00:00:00
mysqlbinlog 指定多文件用*即可;
1、导出指定时间的数据(如果找到这个时间点,按自己的需求,我是找CREATE DATABASE 库名):
./mysqlbinlog --no-defaults --database=onehome_100392330 --start-datetime="2023-02-23 00:00:00" --stop-datetime="2023-04-05 00:00:00" /data/mysql/mysql_bin.00* > tt.txt
2、创建数据库:
CREATE DATABASE onehome_100392330 DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
3、导入:
use onehome_100392330; source /home/tt0223.txt