WAMP Large MYSQL Dump


WAMP Large sql File Export

Often, and especially in the past, PHPMYADMIN in WAMP is not designed to handle the importing of larger sql file.

Here are a couple of quick tips to increase the ability for phpmyadmin to handle large files. 

1) Open the php.ini file:
Click Wamp Server >PHP >php.ini
Find and change the following lines:
upload_max_filesize = 100M
post_max_size = 100M
2) Restart Apache Server.
3) Try importing the file

Note:
You may get the following error uploading a large file:
Set timeout
Fatal error: Maximum execution time of 300 seconds exceeded in C:\wamp\apps\phpmyadmin2.11.6\libraries\import\sql.php on line 118

4) Open C:\wamp\apps\phpmyadmin\config.inc.php
a) Near line 128 you can change the time for which phpmyadmin will execute
b) Change the number.
Before:
$cfg['ExecTimeLimit']           = 300;    // maximum execution time in seconds (0 for no limit)
After:
$cfg['ExecTimeLimit']           = 10000;    // maximum execution time in seconds (0 for no limit)
5) Restart All Services

More Options:
6) a) Open:
my.ini located in C:\wamp\bin\mysql\mysql5.0.51b\my.ini
b) Add the code:
max_allowed_packet = 200M

7) Open:
C:\wamp\apps\phpmyadmin3.4.5\config.inc.php
Look for:
$cfg['UploadDir'] = '';
Change to:
$cfg['UploadDir'] = 'upload';

8) Create a directory called 'upload' in:
C:\wamp\apps\phpmyadmin3.X.X
Copy and Paste sql file to:
C:\wamp\apps\phpmyadmin3.X.X\upload\

9) Restart All Services