1.登录mysql 数据库
CREATE DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE
utf8_general_ci;
1.1更改数据库的字符编码
ALTER DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE
2.导入mysql 数据文件
source /root/20151010.sql
1.登录mysql 数据库
CREATE DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE
utf8_general_ci;
1.1更改数据库的字符编码
ALTER DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE
2.导入mysql 数据文件
source /root/20151010.sql