When phpmyadmin imports files, where do I set the size limit for php.ini?

How to import files in phpmyadmin and set the size limit for php.ini: 1. Modify [upload_max_filesize] in [php.ini] and change related parameters; 2. Create folders A and B in the phpMyAdmin directory To correspond to UploadDir and SaveDir.

phpmyadmin import file, set size limit php.ini method:

(1)Modifying php.ini is suitable for people who have their own servers

Most of them modify upload_max_filesize in php.ini, but after modifying this, this problem is still prompted;

Then change the following:

Modify PHP.ini

• ##file_uploads on switch to allow uploading files through HTTP. The default is ON, that is,

• upload_tmp_dir files are uploaded to the server where temporary files are stored. If not specified, the system default temporary folder will be used

• upload_max_filesize 20m Wangwen business, that is, the maximum value of the file size allowed to be uploaded. The default is 2M

• post_max_size 30m refers to the maximum value that can be received through form POST to PHP, including all values ​​in the form. The default is 8M

Instructions

Generally, after setting the above four parameters, when the network is normal, upload<= 8M files are not a problem

But if you want to upload a large file >8M, it will definitely work if you only set the above four items. Unless your network really has a 100M/S upload speed, you have to continue setting the following parameters.

• max_execution_time 300 The maximum time value (seconds) for each PHP page to run, the default is 30 seconds

• max_input_time 300 Each PHP page receives data The maximum time required, the default is 60 seconds

• memory_limit 128m The maximum memory consumed by each PHP page, the default is 8M

setting The maximum size allowed for POST data. This setting also affects file uploads. To upload large files, the value must be greater than

upload_max_filesize.

If memory limit is activated in the configuration script,

memory_limit will also affect file upload. Generally speaking, memory_limit should be larger than post_max_size.

(2)This method is very simple and does not require modifying the php.ini parameters. It is suitable for people who put the site on a virtual host.

Open the configuration file in the phpMyAdmin directory:

config.inc.php

Please note these two parameters:

$cfg['UploadDir'] = ‘A‘;

$cfg['SaveDir'] = ‘B‘;

In the phpMyAdmin directory Create folders A and B by yourself to correspond to UploadDir (import directory) and SaveDir (export directory).

Export operation:

1. Log in to phpMyAdmin

2. Select the database you want to back up and export on the left side

3 , Find "Export" in the right window

4. Select "Save in the B/directory of the server" at the bottom of the right window

5. Select the compression mode and submit "Execute". The exported data for this database can be found in the B folder.

Import operation:

1. Upload the data file to be imported to directory A

2. Log in to phpMyAdmin

3. Select the database you need to back up and export on the left side

4. Find "Import" (Export) in the right window

5. Select "Website Server Upload Directory" in the right window For the data files that need to be imported, submit "Execute" to complete the import

Related tutorial recommendations:

phpmyadmin

The above is the detailed content of When phpmyadmin imports files, where do I set the size limit for php.ini?. For more information, please follow other related articles on the PHP Chinese website!