• support@answerspoint.com

How to Increase Import Size Limit in phpMyAdmin using Xampp server?

836

Does anyone know if or how you can increase the import size limit in phpMyAdmin? Currently my server is limited to 2MB.

Please note that this is not the same as the upload_max_filesize in php.ini. That value is set to 2MB.

I need to import a table into one of my DBs and the phpMyAdmin restriction of 200MB or more MB Data on the import is preventing me from doing that.

2Answer


0
for import big file in phpmyadmin changes into the php.ini file

post_max_size = 800M 
upload_max_filesize = 800M 
max_execution_time = 5000 
max_input_time = 5000 
memory_limit = 1000M 

now restart for the changes to take effect
  • answered 1 year ago
  • Community  wiki

0

Increase Import Size Limit in phpMyAdmin

Go to php.ini file then change the following configuration:

post_max_size = size 
upload_max_filesize = size 
memory_limit =  size 
  • answered 1 year ago
  • Community  wiki

Your Answer

    Facebook Share