How to modify the upload limit of phpmyadmin

The default phpmyadmin upload file size is 2M. If you want phpmyadmin to upload large files exceeding 2M, you need to modify the size configuration of the phpmyadmin upload file or upload the large file in several batches. It is said that it is much more convenient to modify the upload file size limit of phpmyadmin.

Solving the problem of phpmyadmin upload file size limit involves modifying the php.ini configuration file and phpmyadmin configuration file.

Step one: Modify the file upload size configuration in the php.ini configuration file (Recommended learning: phpmyadmin tutorial)

This The steps are consistent with the general PHP.INI configuration file upload function method. You need to modify the two option values ​​​​up_max_filesize and post_max_size in the php.ini configuration file. (I have tested it myself, assuming it is only 50M, just set it here)

Step 2: Modify the php execution time and memory limit to implement the phpmyadmin upload large file function

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

This is because when phpmyadmin uploads large files, the execution time and memory usage of the PHP page will inevitably become longer and larger. This requires the cooperation of the PHP operating environment. Simply modifying the upload file size limit is not enough.

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 and needs to be modified to 0, that is, there is no time limit.

2. Modify $memory_limit

in the import page under the phpmyadmin installation root directory.

The above is the detailed content of How to modify the upload limit of phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!