Mysql 备份 恢复

来源:互联网 发布:淘宝客服招聘在哪里找 编辑:程序博客网 时间:2024/05/06 10:22

Select *  into outfile '/home/1.text' fields terminated by ',' optionally enclosed by '"' lines terminated by '\n' from test_outfile limit 100;



mysqldump -uroot -T/tmp/mysqldump test test_outfile --fields-enclosed-by=\" --fields-terminated-by=,


mysqlimport --user=name --password=pwd test --fields-enclosed-by=\" --fields-terminated-by=, /tmp/test_outfile.txt


load data infile '/tmp/test_outfile.txt' into table test_outfile fields terminated by '"' enclosed by ',';