Solution to prompt that the file size exceeds the PHP limit during PHPMyAdmin Import

Solution to prompt that the file size exceeds the PHP limit during PHPMyAdmin Import

This article describes how to solve the problem that the file size exceeds the PHP limit when PHPMyAdmin is imported. The cause is that the PHP Upload size is limited to 2 MB and PHP is modified. ini configuration can solve this problem. For more information, see

 

This problem occurs when the website is migrated because the data is always backed up and restored using PhpMyAdmin. However, as the data on the website grows, the database is also growing, there is still 4 MB of data after compression, and an error message is displayed when you import data in PhpMyAdmin.

The prompt "no data to be imported is received" in PhpMyAdmin. It may be because the file name is not submitted, or the file size exceeds the PHP limit. See FAQ 1.16 .".

After searching through the internet, we found a solution because PHP restricts the size of files to be uploaded to 2 MB by default, and we only need to modify this default limit.

Operation Method: Open the PHP configuration file PHP. ini and search for "upload_max_filesize" to change the default value to 2 MB.

 

If the problem persists after the default value is modified, try the following operations.

Search for memory_limit and post_max_size respectively to modify the value. Of course, the modification is larger.

Memory_limit explanation: Set memory;

Post_max_size explanation: maximum value of submitted data