Getting error when importing sql file

Question

when i m trying to load the .sql file into wamp using phpmyadmin

i m getting the fatal error as below

Fatal error: Maximum execution time of 300 seconds exceeded in C:\wamp\apps\phpmyadmin4.5.1\libraries\plugins\import\ImportSql.class.php on line 220

Answer 1

Location: C:\xampp\phpmyadmin\config.inc.php

$cfg['ExecTimeLimit'] = 600;

In C:\xampp\php\php.ini Look for and Change max_execution_time

you already have execution 300 seconds, so go to that file and increase max_execution_time to to what ever you want of seconds.

Answer 2

Add this line

$cfg['ExecTimeLimit'] = 6000;

to phpmyadmin/config.inc.php

And Change php.ini and my.ini

• post_max_size = 750M
• upload_max_filesize = 750M
• max_execution_time = 5000
• max_input_time = 5000
• memory_limit = 1000M
• max_allowed_packet = 200M (in my.ini)

OR

You may also go to xampp\phpMyAdmin\libraries\config.default.php,

and change this line to fix that error.

$cfg['ExecTimeLimit'] = 600;