首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 其他教程 > 互联网 >

into outfile 数据备份及复原

2012-07-28 
into outfile 数据备份及还原一:备份SELECT * FROM mds_ca_user INTO OUTFILE /tmp/s.txt注释:默认数据

into outfile 数据备份及还原
一:备份
SELECT * FROM mds_ca_user INTO OUTFILE '/tmp/s.txt'
注释:默认数据之间用tab;记录自成一行
SELECT * FROM mds_ca_user INTO OUTFILE '/tmp/9.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
注释:即使用,分割字段,双引号限定字段内容,\n分割记录。
二:还原
默认情况:
LOAD DATA INFILE '/tmp/9.txt' INTO TABLE mds_ca_user

默认情况:
LOAD DATA INFILE '/tmp/9.txt' INTO TABLE mds_ca_user
但是有字符分割是
LOAD DATA INFILE '/tmp/9.txt' INTO TABLE mds_ca_user FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

热点排行