Exporting a MySql Database

You can export a MySQL database via phpMyAdmin, available in cPanel, if you want to keep a backup of your records yourself or move the data (or structure) to another database. * * * The first step is to log into your cPanel account. If you are unsure on how to do this, please view the following help article - '[How to log into cPanel](https://hostpresto.com/help/article/1)'. ![alt text](https://i.imgur.com/QRmld56.png "Export MySql database 1") * * * Scroll down to the '**Databases**' section and choose '**phpMyAdmin**'. ![alt text](https://i.imgur.com/fDFcePV.png "Export MySql database 2") * * * Once phpMyAdmin has loaded, from the left hand side, you should see your account name. Click on the '+' icon to expand the available databases on your account. ![alt text](https://i.imgur.com/VEtJmKM.png "Export MySql database 3") *** **Choose the database** that you wish to import your database to from the same left hand side menu. ![alt text](https://i.imgur.com/vA8kYSY.png "Export MySql database 4") * * * Once the database has loaded, select the '**Export**' menu option from the top navigation. ![alt text](https://i.imgur.com/sBmghgj.png "Export MySql database 5") * * * You can choose either **Quick** or **Custom** as an export method and then choose the export format - _SQL format is selected by default_. * **Quick** - selecting the quick export method is recommended for the average user. This will generate a default dump of your database if you are looking to cover all the bases. * **Custom** - selecting the custom export will provide several more options that more advanced users may require such as database choice, specify the output (filename / compression), format specifics (comments, foreign key checks, structure and/or data dumps), object creation options (add statements) and data dump options (insert delayed / ignore statements, update or replace, syntax, max query lengths, further dump requirements). ![alt text](https://i.imgur.com/v05HJ2W.png "Export MySql database 6") *** Once you have chosen your export method (and made any other specifications), select the '**Go**' button. ![alt text](https://i.imgur.com/8uApvSi.png "Export MySql database 7") *** The process will start the export which will be downloaded via your web browser - you may be prompted to save this file depending on your web browser type. Depending on the size of your database, this may take a few minutes to start. ![alt text](https://i.imgur.com/Jnj89AD.png "Export MySql database 8") Exporting a MySQL database via phpMyAdmin is now complete. ***
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to log into cPanel

There are two different methods to log into your cPanel control panel in order to manage every...

What's the difference between Aliases, Addon and Subdomains?

### Aliases An Alias domain does not have a unique website. It is a domain that is masked to...

Creating a MySql Database

If your website uses PHP or you need to hold a collection of records which need to be accessed...

Importing a MySql Database

You can import a MySQL database via phpMyAdmin which is available in the cPanel control panel....

Viewing your Web Stats

Web Stats for your website are important to determine everything about the visitors to your...