mysqldump 全备

备份很重要
mysqldump -S /tmp/mysql.sock -uxxx -pxxx db table | gzip > backup.sql.gz &

创建同名表结构

create table table_bak like table;

导出需要的数据

select * from table where date > '2020-12-31' into outfile '/backup/backup_part.sql'

保留的数据导入到临时表

load data infile '/backup/backup_part.sql' into table table_bak

drop table

drop table table;

rename table

rename table table_bak to table;