If you every get hit by ERROR 1153 (08S01): Got a packet bigger than 'maxallowedpacket' bytes, then this might help. You also need to make sure that the user that you log in with has SUPER privileges on their account.
- #To access mysql console
- mysql -u username -p -h localhost
- #See variable max_allowed_packet and then set it to 100Mb
- SHOW variables LIKE '%max_allowed_packet%';
- SET global max_allowed_packet=1000000000;
- #run import
- mysql -u username -p -h localhost database_name < sql_to_import.sql
CommentsSubscribe to comments
You need to login to post a comment.