导入导出数据库单表数据

为什么80%的码农都做不了架构师？>>>   

导出数据库的数据：

mysqldump -h[ip] -u[username] -p[password] db_name table_name > path/to/file.sql

mysqldump -h[ip] -u[username] -p[password] db_name table_name > path/to/file.sql

注意：如果mysqldump不是全局命令，用绝对路径/path/to/mysqldump

SELECT * FROM `table_name` INTO OUTFILE 'directory' ->e.g /tmp/myTable.csv(Linux) or C:\myTable.csv(Windows) FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'

导入数据：

mysql -h[ip] -u[username] -p[password] db_name < path/to/file.sql

-----------------------------------------

mysql -h[ip] -u[username] -p[password] db_name -e select * from table_name > path/to/file.txt

转载于:https://my.oschina.net/nealma/blog/114467