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

This article mainly introduces how to modify the limitations of phpmyadmin, has a certain reference value, friends in need can refer to. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

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 of the phpmyadmin installation.

Thank you for reading this article carefully. I hope it will be helpful for everyone to share how to modify the restricted content of phpmyadmin. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

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.