phpMyAdmin solution to prompt file size beyond PHP limit when importing

This article mainly introduces the phpMyAdmin import prompt file size beyond the PHP limit solution, causing the problem is the PHP upload size limit of 2MB, modify the php.ini configuration can solve the problem, the need for friends can refer to the

When the site moved to the problem, because the data has been using the phpMyAdmin tool for backup and recovery, but as the site more and more data, so the database is also more and more large, compressed after 4 m of data, and in the phpMyAdmin in the data import when the error prompted.

The phpMyAdmin in the picture above does not receive the data you want to import. Either the file name is not committed or the file size exceeds the PHP limit. See FAQ 1.16. ”。

After a network search to find a solution, because the PHP default limit upload file 2M, and we only need to modify this default limit.

How to: Open the PHP configuration file php.ini, search "upload_max_filesize" to change its default 2M to a larger point on the line.

If you do not resolve the problem after you modify the default, try the following action.

Search Memory_limit and Post_max_size, respectively, to modify their values, of course, to modify the larger.

Memory_limit explanation: Set memory;

Post_max_size Interpretation: Submit data Maximum Value