Thursday 8 November 2018

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

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 50MB or more MB Data on the import is preventing me from doing that.

 Answers


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



Change below lines in php.ini file.
upload_max_filesize = 64M
post_max_size = 64M
max_execution_time = 300
max_input_time = 500000
memory_limit = 256M

0 comments:

Post a Comment