phpmyadmin error : Script timeout passed

phpMyAdmin: Script timeout passed, if you want to finish import, please resubmit same file and import will resume.

If you are not able to upload large sql files in phpmyadmin because of this error, you need to increase your execution time.

Open config file of your phpmyadmin.

If you are using xampp, you will find the config file inside phpmyadmin directory. complete path : /opt/lampp/phpmyadmin/
If you are using apache2 or httpd
complete path : /usr/share/phpmyadmin/

Add following line in the config file.
$cfg['ExecTimeLimit'] = 0;

Restart Apache & mysql both.

Alternate Solution :
Continue Uploading : If you do not have access to server, you can continue uploading the same gzip, sql, zip, or bzip2 file then the data import will pick up where it left off.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...