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