How do I import a .sql file via phpMyAdmin?

You would want to import your database info if you have it in a .sql file. The easiest way to do this would be using phpMyAdmin.

Importing your database backup into phpMyAdmin is very simple just do following:

Step 1. Launch PhpMyAdmin

Log in to your hosting account and navigate to phpMyAdmin from your hosting dashboard.

Step 2. Choose your MySQL database

In the left hand panel select the MySQL database you wish to import the .sql file into. If you don't have Mysql database then just create.

Make sure import to the correct database.

Step 3: Hit the Import Tab

Click the Import tab at the top of your page.

Here is a direct way to upload the database backup file to the database you need.

Step 4: Select the .SQL File

Click Choose File, and browse to the .sql file on your computer/device.

phpMyAdmin supports .sql dump files. They can be used for backup and migration of a website.

Step 5: Begin Import

Choose the .sql file and click Go.

phpMyAdmin will start uploading contents of database and will import to your required MySQL database.

Step 6: Wait for Import to Complete

When complete, you will see a success message that the database has been imported successfully.

Depending on the size of the .sql file it may take a few seconds to a few minutes.

Key Points

Database Size Limitations

1GB MySQL database is included in our web hosting plans. That’s a lot of storage for most small to medium sized sites, blogs, business sites and applications.

Importing .sql Files With phpMyAdmin Discussion

Importing .sql Files With phpMyAdmin is one of the easiest methods to import, restore or upload websites databases. With the above steps you will be able to import database backups into the hosting environment very easily without command line.