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. if you need it, you can refer to the problem encountered when the website was migrated, because the data has been backed up and restored using PhpMyAdmin, however, as the data on the website increases, the database is getting bigger and bigger, and there is still 4 MB of data after compression, and an error message is prompted 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;