How to import large sql file (> 3MB) in wamp using phpMyAdmin

Normally phpMyAdmin imports sql files with less than 3 MB. To upload .sql files with more than 3 MB (usually in wordpress site) we have  to use a diffent method.

Step 1

Move to phpMyAdmin folder usually it is located in "C:\wamp\apps\phpmyadmin3.3.9". 

Step 2

Open file.

Find the code $cfg[‘UploadDir’] =''; and replace it with $cfg[‘UploadDir’] = 'upload';

Save file.

Step 3

Create a folder named upload into the phpMyAdmin folder ( C:\wamp\apps\phpmyadmin3.3.9 ).

Step 4

Copy your database file into the upload directory ( C:\wamp\apps\phpmyadmin3.3.9\upload ).

Step 5

Start WAMP Server then open phpMyAdmin and select any database. Click import option, now you can see a drop down box after web server upload directory option. Select the databse file in the drop down box and press go button.

upload sql file


You can leave a response, or trackback from your own site.

Leave a Reply