How to Import MySQL Database

  •  Log in to cPanel
cPanel Login
  • Under the category "Databases", click on phpMyAdmin

phpmyadmin

  • On the left column, select the database name you wish to import

Select DB

  • Along the top of the screen click the "Import" tab

Import DB

  • Click browse under "File to Import" and locate the .sql file on your computer
  • After you have selected the file, click GO and it will import your database
Go SQL
 
If you wish to export a database: https://gigalayer.com/billing/knowledgebase.php?action=displayarticle&id=82

Note: PhpMyAdmin can only import and export databases up to 50 MB in size
Was this answer helpful?

Also Read

How to Backup MySQL Database in cPanel

You can backup any database on your account using the cPanel backup feature Log into cPanel...

406 Not Acceptable Error

A 406 Not Acceptable Error is indicating that the script you are trying to run is triggering...

How to Change your cPanel Password in cPanel

Often you may want to change your cPanel password for one or more reasons. It is always...

Configuring WHM for the first time.

To begin, please log in to WHM using your root login details for the first time as provided to...

How to Assign/Unassign a MySQL User to a Database

Assign User Privileges to a Database Log into cPanel   Under Databases, click MySQL...