How can I increase the max upload file limit in PhpMyAdmin? I wanted to change the 50 MB limit and increase it to 200 Mb, only to import few large SQL files. I tried to find answers on the internet, and I saw many complicated solutions, part true answers, etc.
So if you own a server and if you can manage Cpanel and WHM, then you can do this easily.
Step 1:
Change in PHP.ini section of WHM (Home »Service Configuration »PHP Configuration Editor):
upload_max_filesize : 200MB
max_execution_time 240 (this is not important, but large files need more time to load – I set 6 minutes)
max_input_time 240 (this is not important, but large files need more time to load – I set 6 minutes)
post_max_size = 200 MB
Step 2:
We need to change the 50MB limit in the PhpMyAdmin section. We need to go in WHM in the Tweak settings section (Main >> Server Configuration >> Tweak Settings ) :
cPanel PHP max execution time 240
cPanel PHP max POST size 200
cPanel PHP max upload size 200
When you finish upload, then you put in default values.
After leaving Wells Fargo Bank in 2014, Daniel began a career as a finance consultant, advising companies and individuals on economic policy, labor relations, and financial management.
At Nimblefreelancer.com, Daniel writes about personal finance topics, value estimation, budgeting strategies, retirement planning, and portfolio diversification.
Read more on Daniel Smith's biography page.
Contact Daniel: daniel@nimblefreelancer.com