Shulou(Shulou.com)06/01 Report--

Xiaobian to share with you phpmyadmin import 20m database example, I believe most people do not know how, so share this article for everyone's reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

phpmyadmin default import database file size is 2M, but the database export files of general websites will exceed this limit, to import more than 2M database files you need to manually modify the php.ini configuration file!

Modify in php.ini file:

upload_max_filesize 20m (i.e. the maximum file size allowed to be uploaded, default is 2M, modify the value to customize the size)

When you're done, refresh the phpmyadin import database page to see that the import database size limit displays "(max limit: 8,192 KB)" instead of the manually set 20m.

That's right, if you only change the upload_max_filesize setting, the php.ini configuration defaults to the size of the post_max_size configuration as the standard for phpmyamdin import database file size limits.

We would therefore also like to make the following changes:

post_max_size 30m (refers to the maximum value that PHP can receive via POST of the form, including all values in the form, default is 8M)

Refreshing the phpmyadin import database page again shows that the maximum limit is changed to 20m, i.e., the upload_max_filesize configuration option is used. After modifying the above two values several times, it is concluded that:

php.ini takes the smaller of upload_max_filesize and post_max_size as valid values for importing database file size limits!!

Note: For the above settings to take effect, you must confirm that:

file_uploads on The above is "phpmyadmin import 20m database example" All the content of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.