Mysql 数据表备份
lock tables 表名 read;
select * into outfile '备份文件' from 表名;
unlock tables;
恢复数据
lock table 表名 write;
LOAD data infile '备份文件' REPLACE into table 表名;
unlock tables;