Cpanel phpMyadmin increase the upload size?

I am using a CentOS server with Cpanel and trying to upload via phpMyadmin.

Is there a way to increase the file size that phpMyadmin will allow? The SQL file I'm trying to import is about 800MB

Is there a file which can be edited in the CPanel installation? At the moment it keeps timing out.  Thank you!
susseditAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Edwin HofferTechnical ExpertCommented:
Hello Sussedit,

For this you need WHM panel assess or php.ini file access.

While doing Google I found this solution: http://stackoverflow.com/questions/12707822/how-to-increase-import-size-limit-in-phpmyadmin#answer-19421353

I hope if you have CentOS then you might have WHM access also.

Also you can ask about it to your hosting company, they can also help you to increase the file size limit.

Hope that helped

Best Regards
Vimal DMSenior Software EngineerCommented:
Hi,

By increasing the following variables in php.ini, you can solve this problem,

upload_max_filesize =
post_max_size =

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
microvbCommented:
If you are talking about the phpMyAdmin that is bundled with cPanel, the only way to bypass it's upload maximum would be to have access to WHM, and manually increase the Max Upload Size in Advanced Configuration.

The alternative, would be if you go to the Remote Access section where you found the phpMyAdmin icon in cPanel, you can add your IP address, and then use a 3rd party tool (I prefer Navicat ), and then use that to `Import` your large SQL file.

The best option, would be to shell into the box, and upload (SCP / FTP / etc) the SQL file to the box, then use the following command to import:

mysql -u <username> -p <mypassword> <mydatabase> < /path/to/large/sqlfile.sql

Replace the bolded segments with the appropriate information.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.