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 account. In this article we will show you how to export your database.
1. Log into your cPanel, under the heading
Databases click on
phpMyAdmin.
2. Click on the database you are working with in the left menu
3. Click
Export in the tabs along the top of the screen.
4. 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.
5. 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.
6. Click on the
Go button in order to perform the export.
7. 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).
