Error while Importing Large files into Mysql database

We may need to adjust maximum allowed file size in my.cnf  file  to avoid   erros such as ” ERROR at line xxx:  MySQL server  has gone  away”.

Mysql_Goneaway

 

adding an entry “max_allowed_packet = 100M”  to my.cnf has fixed the issue

Leave a Reply

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


*