Why is My PHPMyAdmin Import Size Still Limited to 2MB Despite Adjusting php.ini Settings?

Troubleshoot PHPMyAdmin's File Import Size Limit

Despite adjusting the upload_max_filesize and post_max_size parameters in php.ini, users running PHPMyAdmin on Zend Server CE in Ubuntu VirtualBox on Windows 7 may encounter a persistent 2MB import limit.

Solution:

To address this issue, follow these steps:

1. Locate php.ini:

   • For apache2 and php5: sudo gedit /etc/php5/apache2/php.ini
   • For apache2 and php7: sudo gedit /etc/php/7.0/apache2/php.ini

2. Modify post_max_size:

   • Set post_max_size to a value larger than the size of the database (e.g., 25M).

3. Adjust memory_limit:

   • Increase the memory_limit value to a larger value than post_max_size.

4. Check upload_max_filesize:

   • Ensure that upload_max_filesize is smaller than post_max_size.

5. Confirm the Order:

   • The values should be set in descending order:

     • memory_limit > post_max_size > upload_max_filesize

6. Restart Apache:

   • sudo /etc/init.d/apache2 restart

7. Restart Apache Services:

   • Restart Apache services to apply the changes.

By following these steps, the PHPMyAdmin import file size limit should be increased as needed.

The above is the detailed content of Why is My PHPMyAdmin Import Size Still Limited to 2MB Despite Adjusting php.ini Settings?. For more information, please follow other related articles on the PHP Chinese website!