How to Import MySQL database with phpMyAdmin? [STEP BY STEP]☑️
Today in this tutorial we will learn how to import MySQL database with phpMyAdmin. This article will show you how to import an SQL database backup file to your database server with phpMyAdmin. You can also watch this short video tutorial on How to import MySQL database to phpMyAdmin.
If you don’t want to watch the video tutorial, skip and proceed with the text version mentioned below.
Follow the steps given below to import MySQL database with phpMyAdmin:
Step::1 Log into cPanel.
Step::2 Go to DATABASES section and click on MySQL Database
Step::3Create a Database
Step::4Add New User by specifying Username, Password and then click on Create User tab
Step::5 Next Add User to Database By specifying Username and associated Database, then click Add
Step::6 Manage All User Privileges and click on Make Changes tab
Step::7 Now go back to DATABASES section and open phpMyAdmin by clicking the phpMyAdmin icon
Step::8 On the left, select the database that you will be working with and click Import in the top menu.
Step::9 Under File to Import, click Browse and select the backup file you previously created (.sql file)
Step::10 Click Go at the bottom right to import the database file
Step::11 When the database has been imported successfully, you should see a message at the top of the page similar to: Import has been successfully finished, ## queries executed.
Congratulations, you have just imported a MySQL database using phpMyAdmin!