Export MySQL databases

You have two options when exporting your MySQL database. You can either export the entire database, or export selected tables of a database, to a file.

To Export the Complete Database

1. Access your database via PHPMyAdmin (Web & Classic / cPanel / Plesk).
2. From the column on the left select the database that you wish to export.
3. From the tabs at the top of the page select the Export tab.
4. By default Quick is already selected under Export method. Unless you have specific requirements, we suggest you use this setting to export the entirety of the selected database.
5. When you are satisfied with your options, click the Go button. You will be prompted to download the file.

   Note: Web and Classic hosting accounts do not support database compression. What type of hosting account do I have?

Your database has been exported.

To Export Selected Tables Within a Database

1. Access your database via PHPMyAdmin (Web & Classic / cPanel / Plesk).
2. From the column on the left select the database that you wish to export tables from.
3. From the tabs at the top of the page select the Export tab.
4. Under Export Method select the Custom option to see all possible options.
5. In the Tables box remove the check marks from the left of any tables you do not wish to include in your export.

   Note: there are many more options available when using the “Custom” export method. These options are not covered in this article.

6. When you are satisfied with your options, scroll to the bottom of the page and click the Go button. You will be prompted to download the file.

   Note: Web and Classic hosting accounts do not support database compression. What type of hosting account do I have?

The selected tables have been exported.