How to resolve phpMyAdmin Import Database file maximum limit 2048kb_php instance

The solution is as follows:

1, open the php.ini. Find the three parameters of Upload_max_filesize, Memory_limit, Post_max_size!
(In the default case, PHP only allows the maximum upload data is 2M, that is 2048KB, and the limit of the maximum use of memory Memory_limit is only 128m,post maximum also 2M)

2, according to the actual performance configuration of your server to make the following changes: (Note: The following are the changes made by the hardware configuration of my server performance.) ）

upload_max_filesize = 20M (upload maximum limit is set to 8M, this should be enough general file Web upload)

Memory_limit = 512M (because the server's memory is 2GB, so add to 512M here, AH)

Post_max_size = 20M (the maximum post data is also set to 8MB, this is the same as Upload_max)

3, after the change, I re-execute the import command:

Import has been successfully finished, 399 queries executed.
(Show successful import, how many requests were successfully processed ...)

Script Home friendly reminder: After changing the php.ini, do not forget to restart the next Web service or server, oh, restart the rear can be effective.

