mysql 导出导入cmd

mysqldump -u user -h ip -p --set-gtid-purged=OFF databasesname tablename> xxx.sql

mysqldump -u user -h ip -p databasesname > xxx.sql

mysql -u user -h ip -p databasesname < xxx.sql