Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have recently moved some of my sites from shared hosting to VPS. When I am importing SQL files through phpmyadmin or xml files through Wordpress import tool, I am getting error saying "The connection was reset". Can anyone help me with this. I have already made changes to php.ini file. Location of file : /etc/php5/fpm/php.ini I have already changed - max_execution_time = 8000 max_input_time = 8000 post_max_size = 8G upload_max_filesize = 2G Anything other than this.

share|improve this question
up vote 1 down vote accepted

try upping max_packet_size to 2G.... that may fix it.

also, dont import thru gui,,,, ssh in and import in screen, from the cli....

mysql -u user -ppassword dbname < dbname.sql

edit; max_packet_size is a mysql directive, not php. by doing via mysql shell, you are bypassing php and its limits all together.

share|improve this answer
thanks for your help. – Amit Rawat Dec 17 '13 at 10:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.