MySQL server has gone away

MySQL server has gone away

Scene:

MySQL Backup to import times this mistake

Reason:

The imported data is too large to exceed the MySQL default size limit

Solve:

To view MySQL settings:

Show global variables like ' max_allowed_packet ';

Adjust MySQL settings (limit size to 16G, adjust yourself as needed):

Set global max_allowed_packet=10241024x76816;

Look again under

Show global variables like ' max_allowed_packet ';

It's no problem when you import it.

MySQL server has gone away