Export database in phpMyAdmin


EXPERIENCING PROBLEMS WITH OUR SERVICES? RUN A DIAGNOSE FIRST TO SAVE YOURS AND OUR TIME

Added: 10.03.2014 23:26:29     Last updated: 09.01.2017 19:50:35

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.

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

phpMyAdmin icon 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".

phpMyAdmin home page


Step 3:
Click on "Export".

 

phpMyAdmin database page


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.

phpMyAdmin export page

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.

phpMyAdmin export options


Step 6:

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

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