Import / Export a mySQL database using cPanel & phpMyAdmin?

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.
  • import database, export database
  • 0 Users Found This Useful
這篇文章有幫助嗎?

相關文章

How to show hidden files (.htaccess) in cPanel File Manager?

Many users ask us how they can see the .htaccess files for their websites in cPanel File Manager....

How Can I Compress / Uncompress Files Using the File Manager?

How to Compress Files Go to the File Manager. Navigate to the folder where the files you want...

How to View Your cPanel Disk Space Usage?

In order to view your cPanel disk space usage, there’s a great tool located inside of your...

Accessing webmail for your domain

To access the included webmail email clients included with your hosting account, you’ll need to...

How to rename a database in phpMyAdmin?

phpMyAdmin is a free and opensource application for MySQL database management. It is one of the...