ERROR 2006 (HY000) at line : MySQL server has gone away
Suite a la restauration d’une bdd, je rencontre l’erreur
1 |
$ sudo mysql --user=mon_utilisateur --password=mon_mot_de_passe ma_bdd < mon_dump.sql |
1 |
ERROR 2006 (HY000) at line 714: MySQL server has gone away |
Mon dump .sql pèse presque 15mo, il faut donc rajouter la limite max_allowed_packet et définir une taille dans le fichier my.cnf
1 |
$ sudo vim /etc/my.cnf |
1 2 3 4 5 6 7 8 9 10 |
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Settings user and group are ignored when systemd is used. # If you need to run mysqld under a different user or group, # customize your systemd unit file for mariadb according to the # instructions in http://fedoraproject.org/wiki/Systemd <strong>max_allowed_packet=64M</strong> |
Puis redémarrer le service
1 |
$ sudo systemctl restart mariadb |
Puis relancer la restauration
1 |
$ sudo mysql --user=mon_utilisateur --password=mon_mot_de_passe ma_bdd < mon_dump.sql |