Wednesday, 17 June 2015

How to increase import size in phpmyadmin in WAMP:-


how to increase maximum execution time in php, 
How to increase maximum execution time in php, 
How to change maximum execution time in phpmyadmin, 
phpmyadmin max execution time, phpmyadmin import file size, 
phpmyadmin import file size increase, 
Increase the import file size in phpmyadmin wamp, 
Phpmyadmin increase import file size

Solution 1):-
Please follow below settings in C:\wamp\bin\apache\apache2.2.8\bin\php.ini

Find:
post_max_size = 8M
max_execution_time = 30
upload_max_filesize = 2M
memory_limit = 8M
max_input_time = 60

Change to:
post_max_size = 750M
max_execution_time = 5000
upload_max_filesize = 750M
memory_limit = 1000M
max_input_time = 5000

Then restart your wamp to take effect

Solution 2):-
Add this to an htaccess file:
<IfModule mod_php5.c>
php_value post_max_size 200M
php_value max_execution_time 259200
php_value upload_max_filesize 200M
php_value memory_limit 300M
php_value max_input_time 259200
</IfModule>

Solution 3:-
If you don't have access of your php.ini or dont use htaccess file, you can use ini_set in your php file:
For example - ini_set('max_execution_time', 5000);

You can also refer http://forum.wampserver.com/read.php?2,45000 for more informaion

9 comments:

  1. straight forward explanation. nice post

    ReplyDelete
  2. Thank you it worked for me.I wanted to upload magento sample data in my older version of WAMP. but i could not able to import due to import file size restirctions.

    ReplyDelete
  3. I was searching for increase import size in phpmyadmin in WAMP and this code really helps me.. Thanks

    ReplyDelete
  4. Perfect!! it increased my import size in phpmyadmin in WAMP.. Thanks for provide such information

    ReplyDelete
  5. I have been trying for 5 hours to increase the import size and execution size.finally you save my life and increased import size in phpmyadmin in WAMP.Thanx

    ReplyDelete