Mysql匯出/匯入資料

標籤：mysql 匯入匯出

匯出資料
**直接在系統執行命令:
匯出為cvs格式:

[[email protected] ~]# mysql -u root -p密碼 -e "select * from mydb.name into outfile ‘/tmp/12.cvs‘ character set utf8" --character set utf8 指定相應編碼規則,不然可能亂碼

匯出為txt格式:
[[email protected] ~]# mysql -u root -p密碼 -e "select * from mydb.name into outfile ‘/tmp/12.txt‘ character set utf8 lines terminated by ‘\r\n‘ " --匯出為txt檔案時,不加lines terminated by ‘\r\n‘ (結尾符)在windows下會像一團麻一樣.....

在mysql內:

匯出為cvs格式:
mysql>selec t * from mydb.name into outfile ‘/tmp/12.cvs‘ character set utf8; - --character set utf8 指定相應編碼規則,不然可能亂碼

匯出為txt格式:
mysql> select * from mydb.name into outfile ‘/tmp/12.txt‘ character set utf8 lines terminated by ‘\r\n‘; --匯出為txt檔案時,不加 lines terminated by ‘\r\n‘ (結尾符)在windows下會像一團麻一樣.....

匯出為cvs格式後,用WPS開啟,相當的完美!

匯入資料
mysql內匯入:
mysql>load data infile ‘/tmp/12.txt‘ into table name character set uft8; --character set utf8 指定相應編碼規則,不然可能亂碼

直接在系統執行命令:
[[email protected] ~]# mysql -u root -p密碼 -e load data infile ‘/tmp/12.txt‘ into table name character set uft8; --character set utf8 指定相應編碼規則,不然可能亂碼

遇到一個問題:emun類型的欄位,導不入資料 ???

Mysql匯出/匯入資料