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