Categories
PHP

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 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