Exporting a database will allow you to make a backup of your database for safekeeping or to transfer a database to another server. This can be completed using the "Export" option in phpMyAdmin.

Exporting a Database at Web Hosting Hub

  1. Log into cPanel.
  2. Under Databases, click the phpMyAdmin icon.
  3. Select the database that you want to export from the list in the left menu by clicking the database name.
  4. Click the "Export" tab in the menu at the top of the page.
  5. Under the "Export" heading below "View dump (schema) of database"make sure that all of your tables are selected and the SQL option is selected.
  6. Under "Structure" enable the option that reads, "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION."
  7. Make sure "Save as file" is selected in the lower left of the screen. If your database is a large database, you can choose "zipped" or "gzipped" to compress the file for quicker downloading.
  8. Click the "Go" button on the bottom right.
  9. When you are prompted to open or save the file, select "Save" to download the database export to your local computer. Please be sure that you take note of the file name and where you save your backup.

If you have multiple databases, please repeat steps 3-7 for each database you wish to export.

Exporting a Database at Another Host

If your host uses cPanel, the steps to access phpMyAdmin should be similar to the above steps for Web Hosting Hub. If your host does not use cPanel or you do not see  phpMyAdmin in your account control panel, you will want to contact your hosting provider to ask them how to access phpMyAdmin. Once you have accessed phpMyAdmin, please follow steps 3-7 above to export a copy of your database.

phpmyadmin-export

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?

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.