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

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 Run Python Scripts on GigaLayer

All our shared servers are deployed with support for python scripts. However, you need to do a...

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 Assign/Unassign a MySQL User to a Database

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

How to Export a MySQL Database

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