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.


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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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