mysql数据库中利用select into outfile实现数据的备份与还原

主要命令如下：

备份命令select into outfile

SELECT * FROM book2 WHERE price > 75 into outfile 'D:\\book2.txt';

恢复命令load data infile

load data infile 'D:\\book2.txt' into table book2;