Remove the file size limit for phpMyAdmin to import large MySQL Databases

PhpMyAdmin import large database file size limit configuration...

1. Modify the values of the following three items in the PHP. ini file:

Upload_max_filesize, memory_limit, and post_max_size

Upload_max_filesize: the size of the uploaded file.

Memory_limit

Maximum value of data submitted by post_max_size

The size you want to change.

2. modify or add this setting to the phpMyAdmin configuration file:

This file is generally the config. Inc. php file under the phpMyAdmin directory.

$ Cfg ['exectimelimmit '] = 0; // maximum execution time in seconds (0 for no limit)

The default value is 300 seconds. If it is changed to 0, it indicates no restriction.

 

 

Server settings allow uploading larger attachments

Open PHP. ini, first find
;;;;;;;;;;;;;;;;
; File Uploads;
;;;;;;;;;;;;;;;;
Region, which has the following parameters that affect file upload:

File_uploads = on; whether to allow file upload over HTTP. On is enabled by default.

Upload_tmp_dir; upload the file to the place where the temporary file is stored on the server. If it is not specified, the default Temporary Folder will be used.

Upload_max_filesize = 8 m; that is, the maximum file size that can be uploaded. The default value is 2 MB.

In
;;;;;;;;;;;;;;;;;
; Data handling;
;;;;;;;;;;;;;;;;;
Region:

Post_max_size = 8 m; the maximum value that can be received by posting a form to PhP, including all values in the form. The default value is 8 Mb.

Generally, after the preceding four parameters are set, uploading the file <= 8 m is not a problem, but the network is normal.

However, if you want to upload a large file larger than 8 Mb, it is not always possible to set the above four items. Unless your network has a high upload speed of 100 Mbit/s, you have to pay attention to the following parameters:

;;;;;;;;;;;;;;;;;;;
; Resource limits;
;;;;;;;;;;;;;;;;;;;

Max_execution_time = 600; maximum time (in seconds) for running each PHP page. The default value is 30 seconds.

Max_input_time = 600; maximum time required for receiving data on each PHP page. The default value is 60 seconds.

Memory_limit = 8 m; maximum memory consumed by each PHP page. The default value is 8 m.

After modifying the preceding parameters, you can upload a large volume of files as permitted by the network.