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:wampappsphpmyadmin3.3.9”.

Step 2

Open config.inc.php file.

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

Save config.inc.php file.

Step 3

Create a folder named upload into the phpMyAdmin folder ( C:wampappsphpmyadmin3.3.9 ).

 

Step 4

Copy your database file into the upload directory ( C:wampappsphpmyadmin3.3.9upload ).

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

About the author

PHP | MVC | Codeignitor | Zend | Yii | Smarty | Android | Laravel Expert Senior Software Developer.I love my job and feel happy to working on new ideas and technologies.

Leave a Comment

Comment (required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Name (required)
Email (required)