To resolve the phpMyAdmin upload file size Limit configuration method

phpMyAdmin Import SQL file involves phpMyAdmin upload file size limit issue, the default phpMyAdmin upload file size is 2M, if you want to phpmyadmin upload more than 2M large files, It is necessary to modify the size configuration of the phpMyAdmin upload file or to upload large files into several batches, relative to modify phpMyAdmin upload file size restrictions come a lot easier. Resolving the phpMyAdmin upload file size limit issue involves modifying the php.ini configuration file and the phpMyAdmin profile.

Modify the phpMyAdmin upload file size limit main points to modify the PHP.ini profile and phpMyAdmin configuration file two steps.

First step: 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 requires modifying the upload_max_filesize and post_max_size two option values in the php.ini configuration file. For specific modification methods, please refer to: php.ini configuration: File upload feature configuration tutorial.

Step two: Modify PHP execution time and memory limit to implement phpMyAdmin upload large file function

If you want to phpMyAdmin upload large files, you also need to modify the php.ini configuration file max_execution_time (PHP page execution maximum time), Max_input_time (PHP page accepts data maximum time), Memory_ Limit (PHP page occupies the maximum memory) three configuration options, this is because phpMyAdmin upload large files, php page execution time, memory consumption will inevitably become longer and larger, it requires the PHP running environment of the coordination, light modification upload file size limit is not enough.

Step three: Modify the phpMyAdmin configuration file

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

1, modify the phpmyadmin config configuration file $cfg[' exectimelimit ' configuration options, the default value is 300, need to be modified to 0, that is, there is no time limit.

2. Modify the $memory_limit in the Import page of the phpMyAdmin installation root directory

Description: Preferred to read the memory configuration option in the php.ini configuration file Memory_limit, if empty the default memory size limit is 2M, if there is no limit to the memory size limit of 10M, you can combine the information in your php.ini configuration file to modify the code.

At this point, after modifying the file upload configuration options in the PHP.ini configuration file and the phpMyAdmin profile, it is possible to resolve the phpMyAdmin upload file size limit, which allows the phpMyAdmin to upload large file functions.

To resolve the phpMyAdmin upload file size limit configuration method (GO)