This is generally the case when u try to import a database from a dump. The fix is to increase the max_allowed_packet size follow the below steps
- vi /etc/my.cnf
- add: max_allowed_packet=1G under the section [mysqld] and save the file
- restart the mysql: /etc/init.d/mysqld restart;
- it should be smooth, if at all u get a warning telling it will ignore the cnf file, then try
- chmod 655 /etc/my.cnf and again try to restart.
This should do.
No comments:
Post a Comment