As you may already know, WAMP server imposes some pretty strict limits on system resources and allocations. If you are trying to setup a development instance of any large database driven web app on your local machine (ie: Magento), you will definitely need to tweak some out-of-the-box settings in WAMP. In this screencast, we will briefly go over what needs to be changed in the config files in order to get your database imported.
First crack open the php.ini To do this, click on the WAMP icon in your system tray and go to php >> phi.ini. Then find these values:
post_max_size = 8M upload_max_filesize = 2M max_execution_time = 30 max_input_time = 60 memory_limit = 128M
And change them to these values:
post_max_size = 750M upload_max_filesize = 750M max_execution_time = 5000 max_input_time = 5000 memory_limit = 1000M
Lastly, if you are using phpMyAdmin (bundled with WAMP Server), you will need to make one last change in the config file in order to import large databases. Crack open the config.inc.php file, which is typically found in c:\wamp\apps\phpmyadmin\config.inc.php. Then add the following snippet to the bottom of the file, just above the closing PHP tag:
$cfg ['ExecTimeLimit'] = 0;. That’s it – hope this helps someone out there! And without further adieu…