[root@linux1 root]# mysql excell -u assdf -p
Enter password:ads4
mysql> use excell ;
Database changed
mysql> select * from group_map ;
mysql> select * from group_map into outfile
"/tmp/addresslist.txt" ;
mysql> select * from group_map into outfile
"/tmp/addresslist2.txt" fields terminated by "," enclosed by "'"
;
fields terminated 為字段終止符
enclosed 為字段封裝符
效果
'a0001','e100','資訊中心'
load data infile ''/tmp/addresslist2.txt'' into table group_map
fields terminated by '','' enclosed by ''''';
以上為mysql命令模式導入[root@linux1 root]# mysqldump excell >
/tmp/excell.sql -u aden -p
Enter password:
導出所有表創建結構及INSERT數據Mysql執行語句
[root@shlinux A07]# mysqldump adeptechsync emp >
/public/public/emp.sql
導出表emp創建結構及INSERT數據Mysql執行語句
[root@linux1 root]# mysqldump -d excell > /tmp/excell2.sql -u
aden -p
導出所有表創建結構Mysql執行語句
[root@shlinux A07]# mysqldump -d adeptechsync emp >
/tmp/emp.sql
導出表emp創建結構Mysql執行語句
[root@linux1 root]# mysqldump -t excell > /tmp/excell2.sql -u
aden -p
Enter password:
導出所有INSERT數據Mysql執行語句[root@shlinux A07]# mysqldump -t adeptechsync
emp > /root/emp.sql
導出表emp的INSERT數據Mysql執行語句
以上用mysql 資料庫名 < sql文件即可導入
[root@linux1 root]# mysqldump -T/tmp/ excell group_map -u aden
-p
Enter password:
導出數據庫的表的純資料形成文本文件
[root@shlinux A07]# mysqldump -T/tmp/ adeptechsync emp
導出數據庫表emp的純資料形成文本文件
[root@shlinux A07]# mysqldump -T/tmp --fields-terminated-by=,
--fields-enclosed-by=\' adeptechsync emp
adeptechsync庫中的emp表導出到/tmp/emp.txt欄位是用,來分隔,欄位本身是為'套著的.
mysqlimport --fields-terminated-by=, --fields-enclosed-by=\'
adeptechsync /tmp/emp.txt