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:

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 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\
LAMPP Linux: Default in /opt/lampp/phpmyadmin/