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…

Posted by: John Dugan

Comments