How I can increase max upload file limit in PhpMyAdmin ? I wanted to change 50 MB limit and to increase to 200 Mb, only to import few large SQL files. I tried to find answer on internet and I saw a lot of complicated solutions, part true answers etc.
So if you own server and if you can manage Cpanel and WHM than you can do this easily.
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
We need to change 50MB limit in PhpMyAdmin section.We need to go in WHM in 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 than you put in default values.