phpMyAdmin: Increase File Size Limit for Import

You can not change the maximum file size in the phpMyAdmin settings, because the values ​​are taken directly from your PHP configuration.

If you open your php.ini (it can be found in the folder C:\xampp\php when using the default installation of XAMPP), a limit may result from the following settings:

upload_max_filesize=2M
post_max_size=8M
memory_limit=128M
max_execution_time=30

Your upload_max_filesize is probably set to 2 MB, that is why you get that limit. If you increase this value, you should also increase post_max_size and memory_limit, otherwise those variables will create the next limit. The memory_limit should always be bigger than post_max_size and upload_max_filesize should be larger than post_max_size. If you expect the upload to take more than 30 seconds, you must also set the max_execution_time from 30 to a higher value. So for example:

upload_max_filesize=100M
post_max_size=150M
memory_limit=250M
max_execution_time=60

With those settings, you can upload files of 100 MB and you are giving the server one minute (60 seconds) for the upload process. With that settings, phpMyAdmin should show "Max: 100MiB".

Important: You have to restart the server, to get the new values ​​applied!
2017-12-26 at 10:39