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
-
- Login to the cPanel.
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.
Click on the plus sign (‘+’) next to the user name that appears in the column at left. This will expand the database list.
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.
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.
-
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.
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.
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.
I want to import a table exported from a different db into an existing table (without overwriting existing values). How do I do that?
(Right now, the import “into the existing table” actually just creates a new one.) I want to concatenate them.
Thanks
Hey Quantillion, I know that database tasks can go from simple to complicated pretty quickly, so I hope I can offer some tips.
The easiest way to do this is with an SQL query. We cannot directly support coding/programming, but I can point you in the right direction. First, before doing anything make sure you have a secure backup of both databases. You can’t be too careful when making changes like this!
From there, a slower but easy way to do this would be to export the database to a .CSV format, then use SQL code to import only the unique, relevant values from the appropriate table into the new database. I hope that points you in the right direction, but feel free to reach out to our Managed Hosting team if you need someone to assist you with the code directly.