When you export a database, you are creating a backup file of the database. This backup file is usually a .sql file (a text file), and can be used to copy and import the database onto another server. This tutorial will show you how to export your database.

  1. Login to cPanel
  2. Scroll down to the databases section and then click on phpMyAdmin

    If you are not an Web Hosting Hub customer and do not use cPanel, please contact your hosting provider for more help.

  3. Select database to export Click on the database you are working with in the left menu
  4. Click on Export option Click Export in the tabs along the top of the screen.
  5. Export method The export option that we are providing instructions for is the Quick method. Click on the radial button for Quick. If you want more complete control, then click on Custom. You will need to be familiar with the exporting MySQL databases in order to use these options. If you are not, then please consult with an experienced database administrator or developer.
  6. Select the file format Next, you will need to click on the format of the export file. By default, it should be on SQL, so you don't need to change anything.
  7. Click on go Click on the Go button in order to perform the export.
  8. You will be prompted to either open or save the file. Please select the option to save the file and then save the somewhere you'll remember (such as directly on your desktop).

Congratulations, you have just exported a copy of your database!

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Did you find this article helpful?

Comments

n/a Points
2015-01-29 9:57 pm

This article is slightly out dated in terms of what is shown on the export screen today.

Staff
11,798 Points
2015-02-02 1:50 pm
Hello dsksol5,

Thank you for letting us know. We will review this article, and update it as soon as possible.

Thank you,
John-Paul

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.