When trying to import large SQL files into mysql through phpmyadmin, the phpmyadmin documentation offers a some solutions, but this is the easiest method.
1.Find the config.inc.php file located in the phpmyadmin directory. In may located here:
2.Find the line $cfg[‘UploadDir’] on it and update it to:
$cfg[‘UploadDir’] = ‘upload';
3. Create a directory called ‘upload’ within the phpmyadmin directory.
4.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 have 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 what you want and begin the import.
Have a nice day!!!!!!!!