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 Enable Hotlink Protection

To enable/disable hot link protection, follow these simple steps: Log in to cPanel...

How to Assign/Unassign a MySQL User to a Database

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

How to Backup Entire Site in cPanel

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

How to backup my files in cPanel using G1 BACKUP

Required Information To back up your website, you are going to need the following information:...

How to Export a MySQL Database

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