mysql 导入导出数据的方法总结

1. 以文件形式导出数据

https://dev.mysql.com/doc/refman/5.5/en/load-data.html

mysql -P port -u username -h ip -p password -e "use database ;query sql into outfile 'data.txt' FIELDS TERMINATED BY ',' enclosed by '\"' lines terminated by '\r\n'"

2. 以文件形式导入数据

mysql -P port -u username -h ip -p password -e "use database ;LOAD DATA INFILE 'data_file.txt'  INTO TABLE table_name  FIELDS TERMINATED BY ','  OPTIONALLY ENCLOSED BY '\"'  LINES TERMINATED by'\r\n'"

3. 导出sql 文件

mysqldump --single-transaction -P port -u username -h ip -p password database table > table.sql

4. 导入sql文件

mysql -P port -u username -h ip -p password -e  database < table.sql.sql

或者

在mysql终端 source table.sql

5.  使用xtrabackup进行MySQL数据库备份