Home >Database >phpMyAdmin >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
Instructions
Generally, after setting the above four parameters, when the network is normal, upload<= 8M files are not a problemBut 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.upload_max_filesize.
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
$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 phpMyAdmin2. Select the database you want to back up and export on the left side3 , Find "Export" in the right window4. Select "Save in the B/directory of the server" at the bottom of the right window5. 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 A2. Log in to phpMyAdmin3. 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 importRelated tutorial recommendations:
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!