How to solve the phpmyadmin import database file maximum limit of 2048KB, _PHP tutorial

How to solve the phpmyadmin import database file maximum limit of 2048KB,

The solution is as follows:

1. Open php.ini. Find the three parameters upload_max_filesize, memory_limit and post_max_size!
(By default, PHP only allows the maximum upload data to be 2M, which is 2048KB, and the maximum memory_limit is only 128M, and the maximum Post is also 2M)

2. Make the following changes based on the actual performance configuration of your server: (Note: The following are the changes based on my server performance and hardware configuration..)

upload_max_filesize = 20M (The maximum upload limit is set to 8M, which should be enough for general file WEB upload)

memory_limit = 512M (because the server’s memory is 2GB, so adding it to 512M is not excessive, hehe)

post_max_size = 20M (The maximum post data is also set to 8MB, which is the same as upload_max)

3. After making the changes, I re-executed the import command:

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

Friendly reminder from Bangkejia: After changing php.ini, don’t forget to restart the web service or server. It will take effect only after restarting.