How to solve phpmyadmin import database file limit of 2048KB, _ PHP Tutorial

How can I solve the problem that the maximum size of phpmyadmin database files to be imported is 2048KB ,. The solution for phpmyadmin to import database files up to 2048KB is as follows: 1. open php. ini. Find the upload_max_filesize, memory_limit, and post_max_size parameters to solve the maximum limit of 2048KB for phpmyadmin to import database files,

The solution is as follows:

1. open php. ini. Find the upload_max_filesize, memory_limit, and post_max_size parameters!
(By default, php only allows the maximum size of data to be uploaded to 2 MB, that is, 2048KB. The maximum memory usage of memory_limit is only 128 MB, the maximum value of Post is 2 MB)

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

Upload_max_filesize = 20 M (the maximum upload limit is set to 8 M, which should be enough for normal file WEB uploads)

Memory_limit = 512 M (because the server memory is 2 GB, it cannot be added to M here, huh)

Post_max_size = 20 M (the maximum size of Post data is also set to 8 MB, which is the same as upload_max)

3. after the command is changed, run the import command again:

Import has been successfully finished, 399 queries executed.
(Display how many requests are successfully imported ...)

Friendly reminder: after modifying php. ini, do not forget to restart the web service or server. it will take effect after restart.

Solution: 1. open php. ini. Find the upload_max_filesize, memory_limit, and post_max_size parameters...