Showing posts with label phpmyadmin. Show all posts

By default php engine in WAMP Server provides import size of 2Mb. What if someone needs to import a large database, say 20Mb. The Soluti...

How to Increase phpMyAdmin's Import Size How to Increase phpMyAdmin's Import Size

A blog about android developement

phpmyadmin

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.