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 Create/Delete MySQL Database User

To Create a Database User Log into cPanel   Under Databases, click MySQL Databases...

406 Not Acceptable Error

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

G1 Database Backup Walkthrough

Backing up your MySQL database is now easy, reliable, and secure with G1 Backup!  Step 1: Find...

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 Disable APC Cache via .htaccess

You can disable APC Caching for your domain via .htaccess with the following steps: Login to...