How to troubleshoot phpMyAdmin Import database file maximum limit 2048kb_php instance

The solution is as follows:

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

2, according to the actual performance of your server configuration to make the following changes: (Note: The following is based on my server performance hardware configuration changes.) ）

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

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

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

3, after the change, I again execute the import command:

Import has been successfully finished, 399 queries.
(Shows the success of the import, how many requests were processed successfully ...)

Cloud Habitat Community Friendship Reminder: After the php.ini, do not forget to restart the Web service or server Oh, restart the rear can be effective.