“MySQL server has gone away”: This is an error when you tried to import a large file to MySQL/MariaDB. So, you can temporatly set max_allowed_packet by below guide:

Your file size (MB): X

Your file size (bytes): Y = X*1024*1024.

Example: X = 2GB => Y = 2,097,152,000,000

Your import commands likes this:

SET GLOBAL max_allowed_packet=2097152000000
mysql dbname < filename.sql;
,

DMCA.com Protection Status


Leave a Reply

Your email address will not be published. Required fields are marked *