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 200MB or more MB Data on the import is preventing me from doing that.
2Answer
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 7 years ago
- Community wiki
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 7 years ago
- Community wiki
Your Answer