导出表数据
mysqldump -h host -u user -p password --port 3306 --single-transaction --quick --compact -t --set-gtid-purged=OFF database table > table.sql
复制代码
导入表数据
mysql -P port -h host -u user -p password database < table.sql
复制代码
mysqldump -h host -u user -p password --port 3306 --single-transaction --quick --compact -t --set-gtid-purged=OFF database table > table.sql
复制代码
mysql -P port -h host -u user -p password database < table.sql
复制代码