Import MySQL Database Using phpMyAdmin

phpMyAdmin is a tool used for database management. It can be used to import a database to your hosting, in cases where you need to restore a database backup or are migrating your site from another host.

Here we cover the steps to recreate the database and import the database .sql, .zip, or tar.gz file using phpMyAdmin in cPanel.

Related Articles

Import MySQL Database From Command Line
Export MySQL Database Using phpMyAdmin

Create Database

1. Access the appropriate cPanel
2. Create the new database to import to in cPanel with the MySQL Database Wizard or using MySQL Databases
   
   
   1. Enter a name in the New Database field and click Create Database
      
      
   2. Create a new user and add the user to the database, ensuring the new user has all permissions needed

Import Database File

1. Access the appropriate cPanel
2. Under Databases, open phpMyAdmin
   
   
3. Select the new database from the left menu
   
   
4. Choose Import in the top menu
5. Choose Choose File to Browse your computer and select the file you'll be working with from your local computer
   
   CAUTION: Database must be below 50MB. Databases over 50MB can be imported from Command Line.
   
6. Choose Go to begin the import
   
   
7. If there were no errors, the database will be imported successfully.