When migrating your site from another server to ours or if you are restoring a large website backup, you may need to upload or import a MySQL database that is larger than 50mb. Currently, all our shared servers have a limit of 50MB for the database upload in cPanel PhpMyAdmin. This is a global setting on the server that cannot be changed.

You can make a work around to get your database uploaded from your cPanel without contacting support. Softaculous has the ability to install PhpMyAdmin on a subdomain on your account. Installing PhpMyAdmin on a subdomain will allow you to change the php.ini settings that restrict the default PhpMyAdmin from uploading large databases. The following steps will explain how to do this.

Installing a PhpMyAdmin through Softaculous

All shared accounts have the ability to use Softaculous. PhpMyAdmin is available in your Softaculous program for install. The following will show you how to install it.

  1. Login into your cPanel.
  2. Create a subdomain for your PhpMyAdmin.
  3. Go to Software / Services and click Softaculous.
  4. Select PhpMyAdmin from the Database Tools section.
  5. Click install and select the subdomain you created in the Choose Domain Drop box. Leave the In Directory box blank.
  6. Click install.

Next you will need to set the php.ini to allow larger file uploads.

Editing the php.ini to allow large database uploads

  1. Login into your cPanel.
  2. Copy your php.ini from your main domain to your subdomain document root folder.
  3. Edit the php.ini you copied to your subdomain for your PhpMyAdmin.
  4. Change the following to be larger than 100MB. You can make the settings like the example below.
    upload_max_filesize = 256mb
    memory_limit = 256mb
    post_max_size = 100mb

    Save the file.

  5. Make the php.ini recursive in the .htaccess by editing the .htaccess in the subdomain directory and adding the path to your subdomain document root folder.

    That's all there is to it. You will now be able to use your Softaculous installed PhpMyAdmin to upload a database larger than 50mb.

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

0 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!