Steps to Increase Max Import Size Limit in phpMyAdmin – import large sql files


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.

Daniel Smith

Daniel Smith

Daniel Smith is an experienced economist and financial analyst from Utah. He has been in finance for nearly two decades, having worked as a senior analyst for Wells Fargo Bank for 19 years. 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

Inflation Is Eating IRA/401(k) Savings! How to Protect Your IRA/401(k) in Bad Times?

VISIT GOLD IRA

Recent Posts