ubuntu docker安装 mysql5.7并导入数据

下载镜像

docker pull mysql:5.7
#镜像无法下载时可以通过路径下载如：
sudo docker pull docker.m.daocloud.io/mysql:5.7

创建mysql目录

sudo mkdir -p /mydata/mysql5.7/log
sudo mkdir -p /mydata/mysql5.7/data
sudo mkdir -p /mydata/mysql5.7/conf
sudo mkdir -p /mydata/mysql5.7/conf/conf.d
sudo mkdir -p /mydata/mysql5.7/conf/mysql.conf.d
# 目录授权
sudo chown -R docker /mydata

mysql my.cnf配置，目录为/mydata/mysql5.7/conf(windows文件为 my.ini)

[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

[mysqld]
init_connect='SET collation_connection = utf8mb4_unicode_ci'
init_connect='SET NAMES utf8mb4'
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
skip-character-set-client-handshake
skip-name-resolve
max_allowed_packet = 1024M

docker启动 mysql

docker run 
-p 3306:3306 
--name mysql 
-v /mydata/mysql5.7/log:/var/log/mysql 
-v /mydata/mysql5.7/data:/var/lib/mysql 
-v /mydata/mysql5.7/conf:/etc/mysql 
--restart=always 
-e MYSQL_ROOT_PASSWORD=123456 
-d docker.m.daocloud.io/mysql:5.7

数据导入

#登录数据库
mysql -uroot -p
#输入密码
use xxxdb;
#切换数据库

#导入数据时先设置为禁用外键依赖
SET foreign_key_checks = 0;

#数据导入完成后恢复依赖
SET foreign_key_checks = 1;

##进行数据导入
source /xxxx.sql;


#使用 mysql导入命令
mysql -u your_username -p your_database_name < your_data_file.sql