How to increase the phpMyAdmin import file limit
1
Step into the Reading
Baidu Experience: jingyan.baidu.com
PhpMyAdmin is a php-written, web-based way to control and manipulate MySQL databases. Because the operation is simple by the vast number of users who use MySQL, users who use phpMyAdmin may encounter such a problem, when you are ready to import MySQL backup when found unable to import, because the phpMyAdmin import limit is 2M, this can embarrass a lot of users, What can I do to import a backup of a large file?
Baidu Experience: jingyan.baidu.com
Method/Step
- 1
First we want to find the PHP configuration file php.ini file, and then press ctrl+f, search post_max_size, if using their own configuration of PHP, the default value should be 8M, many integration environment for this parameter is not changed, if you want to import a file less than 8M, You do not have to modify this parameter. If it is greater than 8M, modify it to the value you want.
Steps to read
- 2
After configuring Post_max_size, we want to search upload_max_filesize, if you are using your own environment, this value defaults to 2M, if you are using an integrated environment, may be 8M, Then change to the size you want to import (the upper limit of the imported file is the smallest value in Post_max_size and Upload_max_filesize)
Steps to read
- 3
Then we login phpMyAdmin, then click on Import, we look at the right side of the file to be imported, there is a maximum limit, is not changed to the value we set (because although the post_max_size is set to 130M, but Upload_max_ 110M is set in FileSize, so the maximum limit is 110M)
Steps to read
END
Baidu Experience: jingyan.baidu.com
Precautions
Configuration must be changed at the same time Post_max_size and upload_max_filesize to take effect, the maximum limit is the minimum value
When importing large files, it is easy to interrupt, which causes the import to fail or import data is not complete, must pay attention to
experience content is for reference only, if you need to solve specific problems (especially in the areas of law, medicine, etc.), we recommend that you consult the relevant professionals in detail.
Report
Author's statement: This experience is based on the actual experience of the original, without permission, declined reproduced.
vote (4) voted (4)
+1
few (0)
I have questions (0)