How 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.

Modifying the size limit of phpmyadmin upload files mainly involves modifying the php.ini configuration file (in the php installation file) and the phpmyadmin configuration file (config.inc.php).

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

This step is consistent with the general PHP.INI configuration file upload function method and needs to be modified There are two option values ​​​​upload_max_filesize and post_max_size in the php.ini configuration file.

Open the php.ini configuration file and find file_uploads

file_uploads = On

HTTP file upload is allowed by default, and this option cannot be set to OFF.

upload_tmp_dir =

The default is empty. This option is easy to forget when manually configuring the PHP running environment. If this option is not configured, the file upload function cannot be implemented. This option sets the temporary storage space for storing files when uploading. Directory, you must assign a value to this option, such as upload_tmp_dir ='/leapsoulcn', which means there is a leapsoulcn directory in the C drive directory, which is the same as the session configuration. If you are in a Linux environment, you must assign This directory has writable permissions.

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 the php.ini configuration 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), memory_limit (the maximum memory occupied by the PHP page) in the file 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 in the phpmyadmin installation root directory. Instructions: First, read php. The memory configuration option memory_limit in the ini configuration file. If it is empty, the default memory size is limited to 2M. If there is no limit, the memory size is limited to 10M. You can modify this code based on the relevant information in your php.ini configuration file.

At this point, after modifying the file upload configuration options in the php.ini configuration file and the phpmyadmin configuration file, the problem of file size limit for phpmyadmin upload can be solved, thereby realizing the function of phpmyadmin uploading large files.

Recommended related articles and tutorials: phpmyadmin tutorial

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