Shulou(Shulou.com)06/01 Report--

This article mainly introduces the phpmyadmin import file when how to set the size limit php.ini, the article is very detailed, has a certain reference value, interested friends must read it!

Phpmyadmin imports the file to set the size limit php.ini: 1. Modify [upload_max_filesize] in [php.ini] and change the relevant parameters; 2. Create folders An and B in the phpMyAdmin directory to correspond to UploadDir and SaveDir.

Phpmyadmin import file, set the size limit php.ini method:

(1) modify php.ini to apply to people who have their own servers

Most of them modify the upload_max_filesize in php.ini, but after modifying this, they still prompt for this problem.

Then the following changes are made:

Modify PHP.ini

The switch on whether file_uploads on allows files to be uploaded through HTTP. Default is ON, that is, on.

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 lookout business, that is, the maximum file size allowed to be uploaded. The default is 2m

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

Description

Generally speaking, after setting the above four parameters, when the network is normal, uploading 8m large files, only setting the above four items will certainly work. Unless your network really has the upload speed of 100M/S, you will have to continue to set the following parameters.

Max_execution_time 300 maximum time to run per PHP page (in seconds), default is 30 seconds

Max_input_time 300The maximum time required for each PHP page to receive data. Default is 60 seconds.

Memory_limit 128m maximum memory consumed per PHP page. Default is 8m.

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

If memory limits are activated in the configuration script, memory_limit also affects file uploads. Generally speaking, memory_limit should be larger than post_max_size.

(2) this method is very simple, does not need to modify the php.ini parameters, and is suitable for people who put the station on the virtual host.

Open the configuration file in the phpMyAdmin directory: config.inc.php

Note these two parameters:

$cfg ['UploadDir'] =' Achievement [SaveDir'] ='B'

Create folders An and B under the phpMyAdmin directory 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

3. Find "Export" in the right window

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

5. Select the compression mode and submit "execute" to find the exported data of the database in the B folder.

Import operation:

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

2. Log in to phpMyAdmin

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

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

5. Select the data file you want to import in the "website server upload directory" window on the right, and submit "execute" to complete the import.

The above is all the contents of the article "how to set the size limit php.ini when phpmyadmin imports files". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.