Sample Header Ad - 728x90

Which option should I use to avoid error #2006 on MySQL (Docker Compose)

0 votes
0 answers
285 views
I am getting error #2006 - MySQL server has gone away while trying to restore a 11.9 mb database using PhpMyAdmin. It worked with a 4.70 mb database, but not with this one enter image description here I thought that if I put --max-allowed-packet=500M in command it will work, but still getting the same
mysql:
    command: --max-allowed-packet=500M
    container_name: db_mysql
    environment:
      MYSQL_USER: doadmin
      MYSQL_DATABASE: defaultdb
      MYSQL_PASSWORD: mysqlpass3434
      MYSQL_ROOT_PASSWORD: mysqlrootpass3432523
    image: mysql:8
    networks:
      - internal
    ports:
      - 3306:3306
    restart: unless-stopped
    volumes:
      - /root/wordpress/mysql:/var/lib/mysql
Note: I am using a $12 USD premium Intel Droplet on Digital Ocean
Asked by LuisEnMarroquin (101 rep)
Jan 11, 2022, 01:29 AM