Solution for phpmyadmin to modify the maximum size of database files imported to a database by 2048KB

1. Open php. ini. Find the upload_max_filesize, memory_limit, and post_max_size parameters! (By default, php only allows the maximum upload.

1. Open php. ini. Find the upload_max_filesize, memory_limit, and post_max_size parameters! (By default, php only allows the maximum upload.

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 = 8 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)

Post_max_size = 8 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 ...)

(Note: After modification, When you import the command line to phpMyadmin, although (sometimes it may still be displayed as: Maximum: 2048KB/Max: 2, 048KiB ); but you can import the backup files exported from gzip to a database of no more than 8 Mb! In addition, after modifying php. ini, do not forget to restart the web service or server! After restart, it becomes effective !)

This record is helpful to friends who encounter the same problem.