[MDEV-6338] Getting MySQL has gone away when importing a .sql file Created: 2014-06-12  Updated: 2014-06-20  Resolved: 2014-06-17

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.11
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Jorge F. Hernandez Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Windows Server 2008 R2


 Description   

I keep getting this error and I can't get a .sql file to be imported.

I'm using Heidi SQL to do this.

 Comments   
Comment by Elena Stepanova [ 2014-06-12 ]

Try to increase max_allowed_packet value both on the server side and on the client side.

Comment by Jorge F. Hernandez [ 2014-06-12 ]

I did, I changed my.ini in the data folder to 2048M but it still says:

+--------------------+------------------+
 
| Variable_name          | Value      |
 
+--------------------+------------------+
 
| max_allowed_packet | 1048576 |
 
+--------------------+------------------+

Comment by Jorge F. Hernandez [ 2014-06-12 ]

Weird because I have another server configured exactly the same and the other one says:

+--------------------+------------+
 
| Variable_name      | Value      |
 
+--------------------+------------+
 
| max_allowed_packet | 1073741824 |
 
+--------------------+------------+

Comment by Jorge F. Hernandez [ 2014-06-12 ]

I just uninstalled it, re-installed it, added max_allowed_packet line again and it worked.

I wonder why it didn't work the first time.

Comment by Elena Stepanova [ 2014-06-17 ]

Maybe there was another ini file or another section in the ini file that overrode your settings.
Anyway, I assume it's not an issue for the time being. If you have the problem again, please feel free to comment to re-open the report.

Generated at Thu Feb 08 07:11:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.