南风大叔

MySQL容器导入大文件的方法

1. 重启容器(如果需要)

docker stop orbstack_mysql
docker rm orbstack_mysql

docker run --name orbstack_mysql \
  -p 3306:3306 \
  -e MYSQL_ROOT_PASSWORD=123456 \
  -e TZ=Asia/Shanghai \
  -v /etc/localtime:/etc/localtime:ro \
  -d mysql:8.0 \
  --default-time-zone=+08:00 \
  --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

#MySQL