DB restore issue -- Server has gone away

[Prasanth_Kumar_J]

When restoring the DB to getting the following error.

Tried:

_mysql_exceptions.OperationalError: (2006, 'MySQL server has gone away')

When I try this restore command, I get the following error after about 15 Minutes. Anybody know what’s going on and how to overcome this. I tried to increase the limits in the my.cnf file in conf.d folder. Thanks Jay bench --site proman --force restore /home/jay/frappe-bench/sites/proman/public/files/20170215_193210_cce32010_database.sql MySQL root password: Traceback (most recent call last): File “/usr/lib/python2.7/runpy.py”, line 174, in _run_module_as_main “main”, fname, loader, pkg_…

V13 DB restore in v14

I ran into some problem upgrading from v13 in ubuntu 20.04 so, I decided to take backup with files and clean install new ubuntu 22.04 and installed v14 following this guide. There were no problems in installation of ERPN v14. But when I tried to restore the old database, this error appeared. ERROR 2006 (HY000) at line 5828: Server has gone away Table ‘tabDefaultValue’ missing in the restored site. Database not installed correctly, this can due to lack of permission, or that the database name …

Need help to solve this…

[ankush]

MySQL error 2006: mysql server has gone away

few things you can try

[anupd]

Try this:

V13 DB restore in v14

Also, turns out, this error: is caused by large sized SQL file. To mitigate this, you need to add this line to /etc/mysql/my.cnf under [mysqld] max_allowed_packet = 1024M Increase the value as per you need.