Import Big SQL File Into MySQL with phpMyAdmin

less than 1 minute read

If you have problem to import large SQL files into MySql using phpMyadmin, the official documentation offers a few solutions, but the easiest method to solve this problem is:

  • Find the file located in the phpMyadmin directory. If you have Wamp installed, it is probably located here:
  • Find the line with $cfg[‘UploadDir’] on it and update it to:
$cfg['UploadDir'] = 'upload';
  • Create a folder called ‘upload’ in the same folder where file, so now you have:

Then copy the big sql file that you are trying to import into the new upload folder.

Now when you go to phpMyAdmin, at the import page you choose 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 your file, and start with the import.

Simple as that.


Picture source.

If you liked the post, we should get connected - follow me on Twitter

1 Comment Import Big SQL File Into MySQL with phpMyAdmin

Leave a Reply

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