mysql数据库备份命令:select * from tb_trans_log where LOGDATE<'2016-04-15 15:00:32' into outfile 'f:/ee1.txt'
mysql数据库恢复命令:load data infile '/tmp/stud.txt' into table students
如果导出的xls文件是乱码,直接导出为txt文件,以utf-8打开excel
mysql数据库恢复命令:load data infile '/tmp/stud.txt' into table students
如果导出的xls文件是乱码,直接导出为txt文件,以utf-8打开excel