Search in This Blog

Error while import sql file in sqlyog

PROBLEM:
Sometime when you import sql file then you may surprise that error show any time.The sqlyog is the good tool to import or export mysql database, You may get error while import sql file in sqlyog. So how to tackle it?

SOLUTION:
This is because your insert statement is too big to execute. to solve these problem follow listed below statement:

open "my.ini" or "my.cnf" file in the mysql folder
and change this statement as :
"max_allowed_packet=500M"
Previous
Next Post »