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.
- 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.
This completes our tutorial on importing tables into a database. 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.