Importing large file using wamp server phpmyadmin

Importing large file using wamp server phpmyadmin

When trying to import large SQL files into mysql using phpmyadmin, at wamp server it gets error that says “You probably trying to upload large files”.

To get rid of this error I have got a nice solution which is so simple

Find the config.inc.php file located in the phpmyadmin directory. In my case it is located here:

1
C:\wamp\apps\phpmyadmin2.11.6\config.inc.php

Find the line with $cfg[‘UploadDir’] on it and update it to:

1
$cfg['UploadDir'] = 'upload';

Create a directory called ‘upload’ within the phpmyadmin directory.

1
C:\wamp\apps\phpmyadmin2.11.6\upload\

Then place the large sql file that you are trying to import into the new upload directory. Now when you go onto the db import page within phpmyadmin console you will notice a drop down present that wasn’t there before – it contains all of the sql files in the upload directory that you have just created. You can now select this and begin the import.

Leave a comment