How to increase the import file size in phpmyadmin

In general phpmyadmin allows to import file size Max: 2,048KiB
By default you get a 2mb limit of import size in phpmyadmin.It is impossible to import larger files. You can increase the allowed import size of phpmyadmin by editing your server's php.ini configuration file. Usually it is located at {Server}/Php/php.ini.
Here Server is WAMP, XAMPP, VERTRIGO.
Step 1: Go to php.ini and find the upload_max_filesize and post_max_size
Default values
 
upload_max_filesize = 2M
post_max_size = 8M

Change their values to higher value
  
upload_max_filesize = 50M
post_max_size = 50M
Step2 : Restart your server for this new change to take effect.
            Now you can import the larger files easily.

* If you like this post please don’t forget to subscribe Techies Badi - programming blog for more useful stuff


EmoticonEmoticon