Pages Menu
Rss
Categories Menu

Posted by on Jan 25, 2017 in Database, Informatics, Internet | 0 comments

Timeout error in phpMyAdmin during import database from file

Timeout error in phpMyAdmin during import database from file

Timeout during import database from file in phpmyadmin

Timeout error during import database means you have too large file for your settings from configuration files. If you have this problem, you probably saw this message in phpMyAdmin panel:

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

So what next? Size of your backup obviously you can’t change, but config parameters – surely yes.

First. Check your php.ini file and increase values on this lines:

post_max_size = ???M
upload_max_filesize = ???M
max_execution_time = ???
max_input_time = ???
memory_limit = ???M

The “M” letter stand for megabytes.

Second. Check your config.inc.php in phpMyAdmin directory, and add (or edit if exists) this line:

$cfg['ExecTimeLimit'] = 0;

This “zero” is very important.

Restart your services (i.e. Apache, MySQL), refresh browser and try again. Should help.

 

Supplement

Where are these configuration files?

php.ini

XAMPP Windows: Default in: C:\xampp\php\php.ini
LAMPP Linux: Default in: /opt/lampp/etc/php.ini
Still can’t find? Create new .php file with only this line:

<?php phpinfo(); ?>

and find your path to config file in report generated by phpinfo() function.

config.inc.php
XAMPP Windows: Default in C:\xampp\phpmyadmin\config.inc.php
LAMPP Linux: Default in /opt/lampp/phpmyadmin/config.inc.php

Comments

comments

Post a Reply

Your email address will not be published. Required fields are marked *