mysqldump [options] db_name [tables]
mysqldump [options] ---database DB1 [DB2 DB3...]
mysqldump [options] --all--database

mysqldump -uroot -p123456 mysql > mysql_backup.sql

mysqldump -u root -p123456 --database mysql test > my_databases.sql

mysqldump -u root -p123456 --all-databases > all_databases.sql

 mysqldump -u root -p123456 -d --add-drop-table mysql > mysql_define.sql

mysqldump -u root -p123456 mysql | gzip > mysql.sql.gz

mysql db_name < backup-file.sql
mysql -e "source /path-to--backup/backup-file.sql" db_name

gunzip -f < mysql.sql.gz | mysql -u root -p123456 test

SELECT * INTO OUTFILE '/tmp/result.txt' 
FIELDS TERMINATED BY ',' 
OPTIONALLY ENCLOSED BY '"' 
LINES TERMINATED BY '\n'
FROM mysql.user;

LOAD DATA LOCAL INFILE '/tmp/result.txt' INTO TABLE test.user
FIELDS TERMINATED BY ',' 
OPTIONALLY ENCLOSED BY '"' 
LINES TERMINATED BY '\n'

FIELDS TERMINATED BY ','   字段间分割符采用,号
OPTIONALLY ENCLOSED BY '"' 　　　 用"号将字段包围,对数值型无效
LINES TERMINATED BY '\n' 　　　　　 记录间隔符采用\n换行符