Timeout error in phpMyAdmin during import database from file
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.
Where are these configuration files?
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.
XAMPP Windows: Default in C:\xampp\phpmyadmin\config.inc.php
LAMPP Linux: Default in /opt/lampp/phpmyadmin/config.inc.php