Import large files in mysql using PhpMyAdmin

Sometimes when trying to upload some huge SQL file using PHPMYADMIN  we might come across this ERROR MESSAGE

Error: You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit

There is simple a fix for this:-
Find the config.inc.php file located in the phpmyadmin directory. In my case it is located here:

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

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

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.

The new option that you see in the import page will be similar to this