Importing large files into mysql with phpmyadmin

I was attempting to try and upload a large sql file onto my new server but didn’t realize how big it was until it failed. I had to find and find a solution as to why I can get around this and found this excellent article.
“When trying to import large SQL files into mysql using phpmyadmin, the phpmyadmin documentation offers a few solutions, but I find the easiest method to overcome this is… Find the config.inc.php file located in the phpmyadmin directory. In my case it is located here: C:\wamp\apps\phpmyadmin3.2.0.1\config.inc.php. Find the line with $cfg[‘UploadDir’] on it and update it to: $cfg[‘UploadDir’] = ‘upload’; Create a directory called ‘upload’ within the phpmyadmin directory: C:\wamp\apps\phpmyadmin3.2.0.1\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. If you’re not using WAMP on Windows, then I’m sure you’ll be able to adapt this to your environment without too much trouble.”
You can read this article here: http://daipratt.co.uk/importing-large-files-into-mysql-with-phpmyadmin/

Leave a Reply

Your email address will not be published. Required fields are marked *

*

*