InMotion Hosting Support Center

phpMyAdmin is a useful database tool that can be used for a variety of MySQL database operations. The following tutorial covers the import feature. Before you make any changes, be sure that you make a current backup of your database before making any changes. Importing a table means that you will be bringing data and/or a table structure into the database. Note that this different importing a database.

Table imports through phpMyAdmin are limited to 50 MB. Tables larger than 50 MB will require that you submit a ticket to technical support.

How to Import a MySQL Database Table

  1. Login to the cPanel.
  2. phpMyAdmin icon

    In the databases section, click on the icon labeled phpMyAdmin. This will launch the application and you will see the interface open with the list of databases that it can access listed on the left side.

  3. Click click here to see database list

    Click on the plus sign ('+') next to the user name that appears in the column at left. This will expand the database list.

  4. Click click here to see the tables in the database

    Next, click on the name of the database that you wish to use for the import. Before you begin the file import, you will need to make sure that the same table does not already exist. Delete or drop the table with phpMyAdmin before you begin the import if you see that the table already exists. Make sure that you have backed up your database before you delete anything.

  5. Click on browse to see database tables

    You will see the database tables listed in the screen to the right. In the top right of the phpMyAdmin interface, you should see a row of options starting with Browse. Click on Import in order to begin the import process.

  6. Click on IMPORT to start the process

    There are a number of options that you can select with import, but this tutorial deals with the default settings. Click on Choose file in order to choose the file that you wish to import. Please note again, that the file size limit for imports through phpMyAdmin is 50 MB.

  7. Use SQL for the file format

    The format of the file used for import should be SQL. This can be changed by clicking on the drop-down arrow for Format. However, to keep things simple, we are going to be using the default format of .SQL. Click on Go in order to start the import.

Click click here to see the updated table list

In order to double check for the table that you have added, click on the database name to list all of the tables in the right hand portion of the screen. Depending on the size of the table, it may take some time for the import to complete. When the import completes you will be able to look at the tables of the database and see the table that you have imported.

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Social Media Login

   
Social Login Joomla

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!