How to modify the phpmyadmin import file size limit

How to modify the size limit of phpmyadmin import files?

Solution to the problem when PhpMyAdmin prompts that the file size exceeds the PHP limit when importing data

This problem was encountered when the website was moved, because the data has been using PhpMyAdmin Tools are used for backup and recovery, but as the website has more and more data, the database is getting larger and larger, and there is still 4M of data after compression. When importing the data in PhpMyAdmin, an error message appears.

The picture above shows the prompt in PhpMyAdmin "No data to be imported was received. It may be that the file name was not submitted, or the file size exceeded the PHP limit. See FAQ 1.16 ."

After searching on the Internet, I found a solution. The reason is that PHP limits uploaded files to 2M by default, and we only need to modify this default limit.

Operation method: Open the PHP configuration file PHP.ini, search for "upload_max_filesize" and change its default 2M to a larger size.

If changing the default value still does not solve the problem, please try the following operations.

Search memory_limit and post_max_size respectively and modify their values, of course to make them larger.

memory_limit explanation: setting memory;

post_max_size explanation: the maximum value of submitted data;

Recommendation: "PHP Tutorial"

The above is the detailed content of How to modify the phpmyadmin import file size limit. For more information, please follow other related articles on the PHP Chinese website!