MySQL事务与数据库的备份恢复

-- 数据库备份
SELECT * FROM test_db.tb_students_info
INTO OUTFILE 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/file.txt'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '?';

-- 复制表数据
CREATE TABLE tb_students_copy
LIKE tb_students_info;

-- 数据库恢复
LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/file.txt'
INTO TABLE test_db.tb_students_copy
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '?';