Hi,
I am unable to import a large .sql file on phpmyadmin, which is about 50mb in size.
Thank you in advance.
I am unable to import a large .sql file on phpmyadmin, which is about 50mb in size.
Thank you in advance.
This updates the phpMyAdmin that is within WHM. But it does not change the end-user file import size if the end-user clicks on the phpMyAdmin icon in their own cPanel. That is still at 50 for some reason. Changing the settings about DOES affect the phpMyAdmin upload limits for the WHM "version" of phpMyAdmin.Hey @saranyabasu
If you have root level (WHM) access. Check your current settings in WHM's (Home »Server Configuration »Tweak Settings) [ PHP ]. You will want to make sure the following setting is adjusted to be larger than the file size you are trying to upload:
"cPanel PHP max upload size (Minimum: 50; Maximum: 2,047)"
Thank you. I did do that already as well and it does change the upload size limit for phpMyAdmin that is located within WHM, but not phpMyAdmin for end user cPanel. Still looking for a solution.Hello,
Try to change "cPanel PHP Max POST size" also in WHM.
Step : Go to Tweak settings, find the "cPanel PHP Max POST size" change it according to your needs. Save changes
Thank you. This has been suggested and I have tried this, changing both to 200 MBs. This DOES change the upload limit for phpMyAdmin initiated from within WHM. But it does not change the 50 MB upload limit for phpMyAdmin initiated from end-user cPanel's. Any suggestions for getting that changed?Try to increase cPanel PHP max POST size and cPanel PHP max upload size on your server through WHM »Server Configuration »Tweak Settings
A logical suggestion. But this is a case where a 3rd party needs to upload and giving them shell access isn't my first choice. It is basically a one time upload, so I may just have them send me the file.You should upload the sql file to the server and restore it via the command line. Trying to upload and restore a large DB from your browser is a bad idea, IMO.
Probably best. GL!I may just have them send me the file.
Hello,For some reason I had to run this command to get the new php settings to propagate to end user cPanel / phpMyAdmin:
Restart cPanel service:
/bin/systemctl restart cpanel.service
I wouldn't think this would be necessary, but apparently it is. Seems like a bug.
cat /usr/local/cpanel/version
Hello,Yep, just confirmed it. I changed the settings in tweak settings and it changed the upload limit for the WHM phpMyAdmin but not end user cPanel phpMyAdmin.
No, not closing it, just hitting refresh in the browser. WHM version updates with a refresh, cPanel version does not. Doesn't matter if I log out or not. A completely different person from another country didn't see it update either, so I don't think that is the issue.Hello,
Are you closing phpMyAdmin to end the session, and then reopening it? Note that you won't see the change until you close the browser tab/window and then open phpMyAdmin again from within cPanel.
Thank you.
Not yet. Wish the process was a little more streamlined. Always feels like a chore to open one. Reduce the friction for opening a ticket and I think people would be more willing to spend the time to submit and document issues.Hello @vikins,
Were you able to open a support ticket to allow us to take a closer look? If so, could you post the ticket number or let us know the outcome?
Thanks!
Thread starter | Similar threads | Forum | Replies | Date |
---|---|---|---|---|
V | PHPMYADMIN 500 error while importing | Databases | 4 | |
X | Importing Large Database Error | Databases | 1 | |
B | need help importing large 1gb db :( | Databases | 6 | |
G | Importing large MYSQL database | Databases | 3 | |
D | Mysql error importing large db | Databases | 2 |