HOW TO: Import / Export a mySQL database using cPanel & phpMyAdmin

Last modified: April 13, 2020
You are here:
Estimated reading time: 1 min

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.
Was this article helpful?
Dislike 0
Views: 22
Customer Services Contact

Need Help? Send a Ticket to our 24X7 Technical Support Team

Subtitle
Subscribe Newsletter

Subscribe to Casbay Newsletter for online tips, events and latest promotion !

Copyright © 2010 – 2020 Casbay Sdn. Bhd. (1042688-D). All Rights Reserved.

All Trademarks Are The Property of Their Respective Owner.