How to increase the 50MB limit & also the timeout?

deo_hai_van

Active Member
Feb 8, 2011
26
0
51
Hi guys,
I am moving to VPS and I ran into this problem.
My database is 60MB and when I tried to IMPORT through phpMyAdmin, I am not allowed because it is > 50MB
And some people say it is also because of the time out limit
So...
1. how do I increase this limit? I'd like to do this through WHM instead of SSH because I am a noob
2. any of you guys ever tried BigDump and was successful?
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
Hello,

Since PHPMyAdmin uses the cPanel settings for PHP, you'd want to change values in WHM > Tweak Settings for the following:

cPanel PHP max execution time
cPanel PHP max POST size (maximum: 2,047)
cPanel PHP max upload size (maximum: 2,047)
The defaults are the following:

cPanel PHP max execution time --> 90 seconds
cPanel PHP max POST size --> 55 MB
cPanel PHP max upload size --> 50 MB

Thanks!
 
  • Like
Reactions: Kent Brockman

deo_hai_van

Active Member
Feb 8, 2011
26
0
51
Hello,

Since PHPMyAdmin uses the cPanel settings for PHP, you'd want to change values in WHM > Tweak Settings for the following:



The defaults are the following:

cPanel PHP max execution time --> 90 seconds
cPanel PHP max POST size --> 55 MB
cPanel PHP max upload size --> 50 MB

Thanks!
thank you so much