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

This article will explain in detail how to modify the upload restrictions of phpmyadmin. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

By default, the file size uploaded by phpmyadmin is 2m. If you want phpmyadmin to upload files larger than 2m, you need to modify the size configuration of files uploaded by phpmyadmin or upload large files in batches. It is relatively convenient to modify the size limit of phpmyadmin uploaded files.

Resolving the size limit of phpmyadmin uploaded files involves modifying php.ini configuration files and phpmyadmin configuration files.

Step 1: modify the file upload size configuration in the php.ini configuration file

This step is consistent with the general method of uploading PHP.INI configuration files, and you need to modify the values of upload_max_filesize and post_max_size options in the php.ini configuration file. (I have tested it myself, assuming it is only 50m, as long as it is set here.)

Step 2: modify the execution time and memory limit of php to realize the function of phpmyadmin uploading large files

If you want phpmyadmin to upload large files, you also need to modify the three configuration options in the php.ini configuration file: max_execution_time (maximum time for php pages to execute), max_input_time (maximum time for php pages to accept data), and memory_limit (maximum memory consumed by php pages).

This is because when phpmyadmin uploads large files, the execution time and memory footprint of php pages are bound to become longer and larger, which requires the cooperation of php running environment, so it is not enough to modify the size limit of uploaded files.

Step 3: modify the phpmyadmin configuration file

After completing the relevant configuration of php.ini, you also need to modify the phpmyadmin configuration.

1. Modify the $cfg ['ExecTimeLimit'] configuration option in the phpmyadmin config configuration file. The default value is 300, which needs to be changed to 0, that is, there is no time limit.

2. Modify the $memory_limit in the import page under the root directory of the phpmyadmin installation

On how to modify the upload restrictions on phpmyadmin to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.