Step 1: Find the
config.inc.php file located in the phpmyadmin directory. In my case it is located here:
Note: phymyadmin3.4.5 folder name is different in different version of wamp
Step 2: Find the line with
$cfg['UploadDir'] on it and update it to:
$cfg['UploadDir'] = 'upload';
Step 3: Create a directory called ‘upload’ within the phpmyadmin directory.
Step 4: Copy and paste the large sql file into upload directory which you want importing to phymyadmin
Step 5: Select sql file from drop down list from phymyadmin to import.
sumber copas dari :
http://stackoverflow.com/a/20264467 (php.ini dan my.ini)
If even after repeated upload you still get timeout error, pleasechange your settings in
$cfg['ExecTimeLimit'] = 300; to
$cfg['ExecTimeLimit'] = 0; and restart. Now there is no execution time limit (trust we are talking about local server).