How to increase phpMyAdmin import file size in cPanel

[Dan Mark]

Hi Nix,

I want to increase the import file size in phpMyAdmin. I searched in google and found, adjusting upload_max and post_max in php.ini will solve the issue.

I have done as mentioned but still, the upload limit displayed in phpMyAdmin stands the same. Can you please help me here?

[shaan N]

Hi Dan,

You can easily increase the import file size limit from WHM. Please follow the steps mentioned below and update us the output.

1. Login to WHM
2. Goto > Home »Server Configuration »Tweak Settings
3. Choose PHP tab.
4. Increase the value 'cPanel PHP max upload size' and 'cPanel PHP max POST size' according to the size of the file you need to import.
5. Hit save.

Now goto phpMyAdmin and check the import file size limit and you should see newly set value there.

[Dan Mark]

Hi Shaan,

I tried it out and it worked flawlessly.

You saved my whole day.

[shaan N]

Hi Dan,

That's absolutely great to know and thanks for updating the result.

[LucienLon]

Hi Shaan, is there a limit to file size btw?

[agustinjames]

Open phpMyAdmin.
Click on your database / if not available create database
On the right hand screen, find the option called ‘Import’.
Click on ‘Import’.
Click on ‘Browse’ and select your file.
Refresh your Database.
If there’s any problem look at my profile and contact me. I will help you throughout.

But HostingRaja provides the best solution for all this problems visit https://www.hostingraja.in