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
You may get the following error uploading a large file:
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.
$cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit)
$cfg['ExecTimeLimit'] = 10000; // maximum execution time in seconds (0 for no limit)
5) Restart All Services
6) a) Open:
my.ini located in C:\wamp\bin\mysql\mysql5.0.51b\my.ini
b) Add the code:
max_allowed_packet = 200M
$cfg['UploadDir'] = '';
$cfg['UploadDir'] = 'upload';
8) Create a directory called 'upload' in:
Copy and Paste sql file to:
9) Restart All Services