Mysql-数据导入导出

Mysql-数据导入导出

导出到文本

SOURCE_USER=root
SOURCE_DB=aa
OUTFILE=aa.txt
LoG=aa.log
#分隔符|

mysql -u$SOURCE_USER -D$SOURCE_DB <<! 2>> $LOG 1>&2
select tablename,keymap from cut_table where iskeymap=1
into outfile "$OUTFILE"
FIELDS TERMINATED BY '|' ;
!

导入文本

SOURCE_USER=root
SOURCE_DB=aa
OUTFILE=aa.txt
LoG=aa.log
#分隔符|

mysql -u$SOURCE_USER -D$SOURCE_DB <<! 2>> $LOG 1>&2
load data infile '$OUTFILE' into table cut_pkey fields terminated by '|'
(dbname,list_code,pkeyname,pkeyvalue,status);
!