< All Topics

In this tutorial, you will learn how to import a database table using phpMyAdmin. The software can be accessed using the cPanel dashboard, available to users on one of Hosted.com’s cPanel Web hosting plans.

The ability to import databases and tables with phpMyAdmin offers flexibility and adaptability, allowing you to enhance your database systems in response to changing requirements and circumstances.

How To Import A Database Table

This tutorial assumes you’ve already logged in to phpMyAdmin

1. Here’s how to import a Database: Select the Database containing the Table you wish to import on the left. In this example, we will select the “phpmyadmin” Database.

How to Import A Database Table With phpMyAdmin - phpmyadmin Database

Assuming that the Data in any Table is corrupt, you now want to import a saved (exported) copy of the Data.

2. First Delete/Drop the existing corrupted table from your database. This is done by clicking the “Drop” next to each.

3. Click “Browse” to select the saved copy of your Database, which includes the Details Table. In this example, we chose the “test” Table.

How to Import A Database Table With phpMyAdmin - Importing into the Table

4. Click the “Import” button at the top of the page and choose the local File you wish to import. Then, to complete the process, click the “Import” button at the bottom of the page.

How to Import A Database Table With phpMyAdmin - Tables Imported

That’s it! The new database has been successfully imported.

You’ve reached the end of this tutorial. Now you know how to import Databases and Tables using phpMyAdmin.

Additional Information:

Benefits Of Importing Database Tables

phpMyAdmin offers a reliable and versatile solution for importing Databases and Tables, catering to a wide range of scenarios and user skill levels. It can be beneficial for several reasons:

Data Migration

You must move your database along with your website or application frequently when transferring it to a new server or hosting company. phpMyAdmin provides a convenient interface for importing your database to the new environment.

Backup Restoration

If your database is corrupted or loses data, you might need to restore it from a backup. With phpMyAdmin, you can quickly import your backup files and return your database to its initial configuration.

Development & Testing

Working with sample data or importing data from another source for testing may be necessary during the development phase. phpMyAdmin makes this procedure simpler as it imports databases and tables fast.

Database Syncing

You may need to synchronize the databases frequently if your application is running in numerous instances on various servers. This is simplified with phpMyAdmin, which lets you import databases across servers.

Third-Party Integration

Occasionally, backups or database dumps may be sent to you by clients or other third parties. The import feature of phpMyAdmin allows you to include these databases in your system.

Efficiency and Usability

Importing databases and tables with phpMyAdmin is often easier than with alternative database administration software or command-line tools, especially for users not experienced with SQL commands.

Cross-Platform Compatibility

Since phpMyAdmin is an online application, you may use it from any device with an internet connection and a web browser. Importing databases from different platforms and operating systems is now more convenient.

Graphical Interface

Importing databases is made easier with the use of phpMyAdmin‘s user-friendly graphical interface, which also makes it simpler to manage imported files and settings.

Log into Hosted.com Account

1. Go to the Hosted.com Login website page.

How To Login To Hosted.com - Login in to Hosted.com Account

2. Enter your Email and Password and click the “Sign In” button.

Access phpMyAdmin via Your Hosted.com Account

3. You will see the Hosted.com Dashboard, displaying the Manage Account menu on the left and your Account Information, Account Overview on the right and Open Support Tickets below.

How To Login To Hosted.com - Hosted.com Dashboard

4. Click the “Manage Service” dropdown and select your hosting package – our example uses the WordPress Hosting plan. The hosting window will open and you will see Product Information and Quick Manage on the right.

5. Click on the phpMyAdmin icon under the Quick Manage section.

How To Access phpMyAdmin - Hosted.com Dashboard

Access phpMyAdmin via cPanel Dashboard

6. Click on “Manage Services” to view the sub-dropdown menu and select the hosting package for the domain you want to work with – in our example we are using WordPress Hosting.

Access phpMyAdmin via cPanel Dashboard - Manage Services WordPress

7. Click the “Manage” button to the right of the domain name you want to access.

Access phpMyAdmin via cPanel Dashboard - Manage WordPress Domain

8. The display will now show Product Information, Quick Manage, Resource Usage and Site Statistics for that domain name.

9. Under “Product Information”, scroll down to “Control Panel”, which will display cPanel to the right, and click on the “Login” button.

Access phpMyAdmin via cPanel Dashboard - cPanel Login

10. The cPanel Dashboard will now be displayed.

Access phpMyAdmin via cPanel Dashboard - cPanel Dashboard

11. Under the “Database” section, click the phpMyAdmin icon.

How To Access phpMyAdmin - cPanel Database

Access phpMyAdmin via cPanel Online

1. Visit your cPanel URL, either supplied to you through your web host or attained through other sign-up methods.

2. Enter your Username

3. Then enter your Password and click “Log in”.

How To Login To cPanel - cPanel Login

4. Under the “Database” section, click the phpMyAdmin icon.

Was this article helpful?
Please Share Your Feedback
How Can We Improve This Article?