How to change Import file size limit and execution time in PHPMyAdmin

dheerajkumar · March 17

For changing file size limit:

Step1: Start your apache and MySQL from xampp control panel

Step2: Find php.ini file in your XAMPP directory list

search for the post_max_size entry, and enter a larger number, for example:
post_max_size = 25M
Then ensure the value of upload_max_filesize is smaller than post_max_size.

Step3: After Saving Restart your apache and MySQL

For changing execution time:

Step1: Start your apache and MySQL from xampp control panel

Step2: Go to xampp\phpMyAdmin\libraries\config.default.php

Look for : $cfg['ExecTimeLimit'] 
You can change the value assigned to any higher value, like '6000'.
Maximum execution time in seconds is (0 for no limit).

Step3: After Saving Restart your apache and MySQL

By following the above steps you can easily change the upload limit and execution times in PHPMyAdmin