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...

How to Run Python Scripts on GigaLayer

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

406 Not Acceptable Error

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

How to Backup Entire Site in cPanel

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

How to Create a MySQL Database

Log in to cPanel   Under the Databases tab, click MySQL Databases In the New...