1、select ...into outfile ....
备份:
select * from t_name into outfile '/tmp/t_name.sql';
还原:
>load data infile ‘/tmp/t_name.sql' into table t_name;
1、select ...into outfile ....
备份:
select * from t_name into outfile '/tmp/t_name.sql';
还原:
>load data infile ‘/tmp/t_name.sql' into table t_name;