InMotion Hosting Support Center

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.

Support Center Login

Social Media Login

Social Login Joomla

Related Questions

Here are a few questions related to this article that our customers have asked:
Need help for restoring my backup.tar.gz to new server
Import large SQL DATABASE
how to access mysql database using phpmyadmin ?
Would you like to ask a question about this page? If so, click the button below!
Ask a Question
n/a Points
2015-07-04 9:05 am

This seems a good option, however I am stack at the php.ini where can I copied it from? there is no php.ini in my main domain. if I copy one from my own computer then the phpmyadmin doesn't load.

30,246 Points
2015-07-06 3:58 pm
If you are one of our customers. You can contact our Live Support team for a copy of the server's php.ini folder to be placed on your account.
n/a Points
2015-09-14 9:06 am

I Need help upload for larg database table

30,246 Points
2015-09-14 1:53 pm
We are glad to take a look. What type of issue are you having?

Post a Comment

Email Address:
Phone Number:

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

5 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?


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:
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!