ERROR 2006 (HY000) at line 2968: MySQL server has gone away
This error usually happens while restoring large database dumps in MySQL.
This article explains the steps to resolve this problem.
Step1: Login to the MySQL server via SSH as root.
Step2: Open the MySQL configuration file.
Step3: Add or modify the following line.
Please note that this vale might need to be increased according to the size of the database.
Step4: Restart MySQL service.
#systemctl restart mysqld
Now we can restore the dump file without any issues.