Upload large SQL file in PHPAdmin XAMPP

Hello Friends,

Whats about if we want to import the SQL file in XAMPP PHPAdmin?  By Default we can import the SQL file upto 2 MB only.  But if we want to upload the sql file having size 5MB?

There is a trick to do so.  You can upload a sql file upto 128 MB.  You need to modify a file call php.ini (at the same place where you can find the php.exe file).  You can locate this file at

Xampp_Installed_Directory/php/php.ini

open this file in any text editor and search for 'post_max_size' and 'upload_max_filesize' and change the allocated size to both make them 8MB.  Restart the Apache and try it again, now you will see PHPAdmin  saying you can upload the sql file upto 8MB. :)

post_max_size = 8MB
upload_max_filesize = 8MB

Happy Trick :)