How to increase phpMyAdmin import file size in cPanel

Discussions related with hosting control panels used, which include cPanel, Plesk, Directadmin etc..

Moderator: Staff

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 »

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

Re: How to increase phpMyAdmin import file size in cPanel

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


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 »

Hi Shaan,

I tried it out and it worked flawlessly.

You saved my whole day.


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

Re: How to increase phpMyAdmin import file size in cPanel

Post by shaan N »

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 »

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 »

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


If you are looking for assistance in server management, please get in touch with our support.
Post Reply