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 Export a MySQL Database

Log in to cPanel   Click phpMyAdmin under the Databases tab On the left...

How to Backup Entire Site in cPanel

You can backup your entire site including databases, e-mails, settings etc using the cPanel...

406 Not Acceptable Error

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

How to Create a Subdomain

Log in to your cPanel Navigate to Subdomains under the Domains tab Enter the...

How to Assign/Unassign a MySQL User to a Database

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