How to Import Database Using phpMyAdmin on cPanel Server?

Import database using phpMyAdmin on cPanel

Import Database using phpMyAdmin

A database is a collection of information which is organized to provide efficient retrieval. Most of the databases contain multiple tables and each with different fields. You can import a SQL file to your account through phpMyAdmin. To import database using phpMyAdmin on cPanel server, find the below steps

Step 1: Login to cPanel

Step 2: Select phpMyAdmin in the database section

Step 3: Redirected to phpMyAdmin Homepage. Then select the desired database in phpMyAdmin home page

Step 4: Select the option Import for importing the database

Step 5: Choose the file which is to be imported with the option “Choose file” and then select the file

Step 6: The Selected file name will be reflected on phpMyAdmin page

Step 7: Click Go button to Execute the SQL queries

Step 8: The database is updated successfully and displays a message at the top of the page

Step 1 Login to cPanel.

Step 2 Go to Database Section. Select phpMyAdmin option in the Database section.

Go to Database Section Select phpMyAdmin

It has all the specific feature to manage the database.

Step 3  After clicking the phpMyAdmin. It will redirect us to phpMyAdmin Homepage.  In phpMyAdmin home, select the desired database.

Select the Database

Step 4 Select import option for importing a database and it will redirect to the next page.

Select Import Option

Step 5 Click the option Choose File and then browse the file in local machine.

Click on Choose File Button and Browse a File

Step 6 The Selected file name will be reflected on phpMyAdmin page.

Selected File Reflected in phpMyAdmin

Step 7 Click Go button to Execute the SQL queries.

Click Go Button in phpMyAdmin

Step 8 The Database is updated and a success message is displayed at the top of the page.

Success Message is Displayed

Step 9 Done!