Import file size limit in PHPMyAdmin

Performance tuning is very important and there are still a lot of question around, here our tips to help base on our experience.

1. Import file size limit in PHPMyAdmin

For uploading large files through PHPMyAdmin, follow these steps:

• Step 1: Open your php.ini file.
• Step 2: Upgrading Memory Limit:

memory_limit = 750M

• Step 3: Upgrading Maximum size to post:

post_max_size = 750M

• Step 4: Upgrading Maximum file-size to upload:

upload_max_filesize = 1000M

• Step 5: Upgrading Maximum Execution Time:

max_execution_time = 5000

• Step 6: Upgrading Maximum Input Time:

max_input_time = 3000

• Step 7: Restart your xampp control panel.

2. Maximum execution time in phpMyadmin

Please go to:

xampp\phpMyAdmin\libraries\config.default.php

Look for : $cfg[‘ExecTimeLimit’] = 600;

You can change ‘600’ to any higher value, like ‘6000’.

Maximum execution time in seconds is (0 for no limit).