Import database using phpMyAdmin

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

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

Select the Database

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

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

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

Selected File Reflected in phpMyAdmin

Step 7 Click Go button to Execute the SQL queries.
Click Go Button in phpMyAdmin

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

Success Message is Displayed

Step 9 Done!