How to increase phpMyAdmin import file size in cPanel

Discussions related with hosting control panels used, which include cPanel, Plesk, Directadmin etc..
Post Reply
Dan Mark
Posts: 0
Joined: Sat Sep 17, 2016 8:11 am

How to increase phpMyAdmin import file size in cPanel

Post by Dan Mark » Fri Aug 03, 2018 8:56 am

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
Posts: 5
Joined: Sat Sep 17, 2016 3:18 pm

Re: How to increase phpMyAdmin import file size in cPanel

Post by shaan N » Fri Aug 03, 2018 9:03 am

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.


Shaan N
Linux Support Engineer.
Nixtree Solutions
Managed Full Server Backups
https://www.nixtree.com/managed-backups.php

Follow us on : https://twitter.com/nixtree

Dan Mark
Posts: 0
Joined: Sat Sep 17, 2016 8:11 am

Re: How to increase phpMyAdmin import file size in cPanel

Post by Dan Mark » Fri Aug 03, 2018 9:06 am

Hi Shaan,

I tried it out and it worked flawlessly.

You saved my whole day.



shaan N
Posts: 5
Joined: Sat Sep 17, 2016 3:18 pm

Re: How to increase phpMyAdmin import file size in cPanel

Post by shaan N » Fri Aug 03, 2018 9:07 am

Hi Dan,

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


Shaan N
Linux Support Engineer.
Nixtree Solutions
Managed Full Server Backups
https://www.nixtree.com/managed-backups.php

Follow us on : https://twitter.com/nixtree

LucienLon
Posts: 0
Joined: Thu Dec 06, 2018 3:28 pm

Re: How to increase phpMyAdmin import file size in cPanel

Post by LucienLon » Fri Dec 07, 2018 5:08 pm

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



agustinjames
Posts: 0
Joined: Wed Jan 02, 2019 12:02 pm

Re: How to increase phpMyAdmin import file size in cPanel

Post by agustinjames » Wed Jan 02, 2019 12:07 pm

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



Post Reply