Knowledgebase: Database
HOW TO: Import / Export a mySQL database using cPanel & phpMyAdmin
Posted by on 28 November 2017 03:43 PM

This tutorial assumes that you have already created a database. If you have not, you will need to do so first. To import a database into an existing database (.sql file) in cPanel using phpmyadmin follow the steps below.

  1. Log into your cPanel account
  2. Locate the “phpMyAdmin” icon found under the “Databases” section
  3. After phpMyAdmin loads, click on the “Import” tab.
  4. Click on the “Choose File” button and select your .SQL file.
  5. Click on the “Go” button and your MySQL database will import.

To export a mySQL database, you can follow the steps below to do so.

  1. Log into your cPanel account
  2. Locate and click on the “phpMyAdmin” icon under the “Databases” category
  3. Once phpMyAdmin loads, select a database from the left that you wish to export from the list on the left
  4. Click on the “Export” tab and select an export option (see below for export options)
  5. Click on the “Go” button and the database export will begin

Export options:

  • Quick – Export the entire database using the default options.
  • Custom – Select specific tables within the database to export, or change the individual export options.
(0 vote(s))
Helpful
Not helpful

Comments (0)
Copyright © 1998 - 2021 Shinjiru International Inc. All Rights Reserved.