I'm using the following command to import data from a 160 MB file created on another server with mysqldump. The environment I'm importing to is running the latest WAMP Server with max_allowed_packet set to "16M".
C:\wamp\bin\mysql\mysql5.1.36\bin>mysql --max_allowed_packet=15M -u root -pXXX drupal < C:\prod.sql ERROR 2006 (HY000) at line 644: MySQL server has gone away
This seems to happen consistently after approximately 39 seconds and 85.5 MB imported.
I read many suggestions on increasing max_allowed_packet in my.ini, so I did to 16M rather than the default of 1M. Yet the error I'm receiving persists no matter what I do. Any ideas?
Now solved in my.ini:
[wampmysqld] port = 3306 socket = /tmp/mysql.sock key_buffer = 384M max_allowed_packet = 100M table_cache = 4096 sort_buffer_size = 2M net_buffer_length = 2M read_buffer_size = 2M read_rnd_buffer_size = 64M myisam_sort_buffer_size = 64M basedir=c:/wamp/bin/mysql/mysql5.1.36 log-error=c:/wamp/logs/mysql.log datadir=c:/wamp/bin/mysql/mysql5.1.36/data thread_cache_size = 8 query_cache_size = 32M innodb_buffer_pool_size = 384M innodb_additional_mem_pool_size = 20M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 10M innodb_log_buffer_size = 64M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 100 wait_timeout = 28800 [mysqldump] quick max_allowed_packet = 100M [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M