Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.