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.
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 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.