1 Topic by Kelzo (edited by Kelzo 2015-03-14 14:47:24)

  • Registered: 2014-10-09
  • Posts: 10

You need to go to my.cnf file and set max_allowed_packet = 128M

This is because your server is kicking you from receiving such large data.

(LordUsagi)

  • From: Canada
  • Registered: 2014-03-17
  • Posts: 410

You need to go to my.cnf file and set max_allowed_packet = 128M

This is because your server is kicking you from receiving such large data.

3 Reply by Kelzo (edited by Kelzo 2015-03-14 14:46:34)

  • Registered: 2014-10-09
  • Posts: 10

Thanks mate

  • From: Canada
  • Registered: 2014-03-17
  • Posts: 410

Not a problem mate, I had the same problem with SQLYog spitting out this error.

  • Laur
  • Laur
  • Member
  • Offline
  • From: Romania
  • Registered: 2015-08-27
  • Posts: 17

Also beside that to import high .sql files u need to use SQLYog (very good tool for high sql imports/query's into DB). i use this to import world db and other hing sql files larger then 64mb.

Master of PHP
  • Registered: 2014-11-06
  • Posts: 27

For Importing Large SQL files,  MYSQL Commandline is faster and simple. I always use it.

  • Registered: 2015-05-07
  • Posts: 150

correct, its the most fastest way for importing sql.