I'm trying to import ~1GB .sql file which contains INSERTS
. I'm using following command to do so: mysql -u root -p databae < database.sql
but I keep receiving an error MySQL server has gone away
.
I've tried increasing max_allowed_packet
to 64M but no change.