How to import large sql file in wamp using phpMyAdmin

 Fatal error:   

  Maximum execution time of 300 seconds exceeded in

 C:\wamp\apps\phpmyadmin3.3.9\libraries\dbi\mysqli.dbi.lib.php

Solutions : 1

Step 1

Go to to phpMyAdmin folder usually it is located in "C:\wamp\apps\phpmyadmin3.4.5".

Step 2

Open config.inc.php file.

Find the code  

$cfg['UploadDir'] =''; and replace it with $cfg['UploadDir'] = 'upload';

add the new line

$cfg ['ExecTimeLimit'] = 0;

Save config.inc.php file.

Step 3 

Now u can upload 3mb sql file  in phpmy admin

Step4:

Enjoy Folks

Solutions : 2

You can change these values by left clicking wamp > php > php.ini


Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M