Export and create a backup of MySQL database

If you want to export a database for storage copies or for use the same MySQL base in a new project-site is enough to complete the following steps:

1. Log into your cPanel 

2. In the search field type PhpMyAdmin or simply find this application in cPanel and click on it:


3.
 A window will open where you can manage your existing databases. To export a certain base and save it on your computer, you need to find it in the list of databases and click on it:


4. When the selected database opens, click on Export in the top of the screen:


5. In the next step you can leave the default settings and click on the Go button to download the database:


6. In the last step, select the location on your computer where it will be downloaded the selected database and click on button Save:


In this way, the MySQL database is exported, and backed up on your computer. Keep in mind that in this manner it does not remove the database, but it takes a copy.
  • 5 Users Found This Useful
Was this answer helpful?

Related Articles

Working with SQL databases

In order for your MySQL database to work as intended, it will need a script calling or querying...

What is Parked domain?

A parked or Alias domain is a domain that you add to your cPanel account and that domain...

How to create a subdomain in cPanel?

In the latest versions of cPanel, the process of adding a subdomain is similar, but the interface...

What is Addon domain?

An addon domain is a fully functional domain that can be created from within your control panel....

How to Log into cPanel

cPanel Access You can access your cPanel in any of the following ways: Option 1: If you are...