Categories
MySQL

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).

By sysomeho

Ho Sysome obtains B.S. degree in Computer Science from Phnom Penh Internation University (PPIU) in 2013 and currently studying Master of Science in IT (MSIT) at Asia Euro University (AEU). He worked as an IT Officer at Microfinance Institute and Bank in Phnom Penh. He is familar in programming language such as VB.NET, Java (Java2EE, Spring), Codeigniter, Laravel, mysql, sql server and so on. He enjoys sharing knowledges, learns from other, and develop himself.
Find him on Facebook: Spy Ro, Linkedin: Sysome HO.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.