Search our ENTIRE knowledgebase

This guide details how to proceed to export a MySQL/MariaDB database in phpMyAdmin in cPanel. This can be useful in serveral cases, for example if an installation should be moved to a new server, or you need a local copy/backup of the database. This guide requires you to first log into cPanel.

Step 1:
Click on the icon for "phpMyAdmin" as shown in the screenshot below in cPanel:

Step 2:

1. Notice which version of MySQL is running on the server where you export your database when this can be important infomation when importing (recovery) of the database on a different server.
2. Click on the database you want to export in the list of databases. In this case it will be the database "ittdoubc_wp330".

Step 3:
Click on "Export".

Step 4:
In phpMyAdmin there are two ways to export a database; "Quick" and "Custom". The simplest way is naturally to choose "Quick".

1. Choose "Quick - show minimum alternatives"
2. Choose which format the database should be exported in.
3. Click on "Perform" to start the export and download the file.

Step 5:
If you have specific needs or desire more control over the export, you choose "Custom". Here you will have many alternatives, and note that here we will only go through the most common.

1. Click on "Custom - show all alternatives"
2. Click on "Choose all" to mark all tables in the database. If there are tables you do not want to export, they should not be marked here.
3. Choose which charset should be used. This is important to know for any import, and utf-8 will work in most cases.
4. Chose desired compression for the file. If you are exporting a large database, you should choose "gzipped" or "bzipped", for example, to reduce the file size.
5. Choose which format the database should be exported in.
6. Choose whether the exported database should be compatible with other/older systems or not. Unless you have specific needs you choose "NONE" here.
7. If you are copying the database into an empty database, you must pick INSERT which is also a standard choice. If you are overwriting data in a database that already contains data, you must choose UPDATE.
8. Click on "Perform" to start the export.

Step 6:

1. Tick off for wanting to save the file.
2. Click OK to download and save the file locally.

Done
We have now been through how to export a MySQL/MariaDB database in phpMyAdmin.