导出数据的命令:
mysqldump -u root -p password yourdb > yourdb.sql
导入时先创建库:
CREATE DATABASE `yourdb` DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_unicode_ci;
注意: 此处字符集如果使用utf8mb4会报错
COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4'
导入数据的命令:
mysql -u root -p yourdb < yourdb.sql