MySQL容器导入大文件的方法

南风大叔 2022-12-25 笔记

# 1. 重启容器(如果需要)
docker stop orbstack_mysql
docker rm orbstack_mysql

docker run --name orbstack_mysql \
  -p 3306:3306 \
  -e MYSQL_ROOT_PASSWORD=123456 \
  -d mysql:8.0 \
  --max_allowed_packet=20G \
  --innodb-page-size=32768 \
  --innodb-default-row-format=dynamic \
  --innodb-file-per-table=ON \
  --innodb-strict-mode=0

# 2. 等待启动
sleep 10

# 3. 创建数据库(去掉 ROW_FORMAT)
docker exec -it orbstack_mysql mysql -uroot -p123456 -e "
CREATE DATABASE IF NOT EXISTS your_db_name 
  CHARACTER SET utf8mb4 
  COLLATE utf8mb4_unicode_ci;
"

# 4. 导入数据
docker exec -i orbstack_mysql mysql -uroot -p123456 your_db_name < your_backup.sql