How to Increase phpMyAdmin's Import Size

How to Increase phpMyAdmin's Import Size

By default php engine in WAMP Server provides import size of 2Mb. What if someone needs to import a large database, say 20Mb. The Solution to increase the database size is given and which changes the original configuration permanently.

Open php.ini files in C:\wamp\bin\php\php5.3.5 and C:\wamp\bin\apache\Apache2.2.17\bin and perform following in both files.
  1. Locate upload_max_filesize and set its value as large as you want.
    For example upload_max_filesize = 100M (M denotes Mb)
  2. Locate post_max_size and set its value as large as upload_max_filesize.
    For example post_max_size = 120M
  3. Locate memory_limit and set its value as large as post_max_size.
    For example memory_limit = 140M

What if we didn't change post_max_size?
By default post_max_size is set to 8M. So, phpMyAdmin will not extend it's import size greater than 8M.


Share this

Related Posts

First

1 comments:

comments
4 January 2019 at 22:32 delete

In this article is helps lots to Increase phpMyAdmin's Import Size
thank you so much

Reply
avatar

Please Comment about the Posts and Blog