One of the more infuriating problems that you will encounter with WAMP is that it will refuse to import an SQL file. Too big, it says.
Google this problem and you will learn that it is down to phpmyadmin and that there are three possible ways forward.
- Adjust our php.ini settings to allow a larger file
- Use the command prompt to run mysql.exe commands
- Edit the .sql file
There is a fourth way forward that is so much simpler. Hat-tip to this UK web developer.
- Go to c:/wamp/apps/phpadmin3.5.2
- Make a new subfolder called ‘upload’
- Edit config.inc.php to find and update this line: $cfg[‘UploadDir’] = ‘upload’
Now when you import a database, you will given a drop-down list with all the files in this directory. Chose the file you want and you are done.
Note though, that you only set up this procedure once – at the time you set up WAMP. So you will forget this procedure! That is why I have put it on my blog.
Another note to myself – if I have not checked rewrite_module in Apached modules, I should do so now. That is the other modification to the standard install of WAMP that gets forgotten.
- Two Important Tips when using WordPress on a local server like WAMP
- How to change the port numbers on WAMP and stop conflicts with a portable server
- 12 steps to rebuild your WAMP server without losing your data
- Step 3: Get Ushahidi going in your community – install the code (about 1 hour)
- 5 minute install of DRUPAL on WAMP