mysql 数据导入导出，以及问题解决策

创建数据库，将已有的表结构和数据导入到DB中
CREATE DATABASE DBName;
use DBName;
set names utf8;
source C:/mysql_back/XXX.sql;

将DB权限付给指定用户
GRANT ALL PRIVILEGES ON DBName.* TO 'dbuser'@'XX.XX.XX.XX' IDENTIFIED BY 'DBPassWord' WITH GRANT OPTION;
FLUSH PRIVILEGES;

将指定的数据库中的指定表导出
mysqldump -h XX.XX.XX.XX -u dbuser -p DBName tableName > C:/mysql_back/XXX.sql;

如果表中数据有重复值，去重重复数据，需要加--insert-ignore，忽略重复值
-t 只导出表数据，不导出表结构
mysqldump -h XX.XX.XX.XX -u dbuser -p DBName tableName -t --insert-ignore > C:/mysql_back/XXX.sql;

将数据导入到指定数据库
mysql -h XX.XX.XX.XX -u dbuser -p DBName <  C:/mysql_back/XXX.sql;

问题解决策
Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions, even those that changed suppressed parts of the database. If you don't want to restore GTIDs, pass --set-gtid-purged=OFF. To make a complete dump, pass --all-databases --triggers --routines --events.
数据导出时，如果有上面提示，需要加上参数--set-gtid-purged=OFF
mysqldump -h XX.XX.XX.XX -u dbuser -p --set-gtid-purged=OFF DBName tableName -t --insert-ignore > C:/mysql_back/XXX.sql;

ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
数据导入时，出现上面的错误，需要在导出的时候加上参数--set-gtid-purged=OFF
mysqldump -h XX.XX.XX.XX -u dbuser -p --set-gtid-purged=OFF DBName tableName -t --insert-ignore > C:/mysql_back/XXX.sql;