Skip to content
Bacan
EN
English EN Deutsch DE Français FR Nederlands NL Español ES Italiano IT Português (BR) PT Polski PL 日本語 JA
Register
Help Center

How to Export a Database

Learn how to export a MySQL database step by step from cPanel or DirectAdmin. A quick, clear, and safe guide for backups and migrations.

Web Hosting

Exporting a database is a very common and useful task, whether for making a backup, migrating a website, or simply saving data for safekeeping. Here is how to do it step by step, from both cPanel and DirectAdmin, clearly and without complications.

💾 What does "exporting a database" mean?

Exporting a database means creating a file (usually .sql) that contains the entire structure and data of your database. You can save this file, move it, or import it later on another server.

✅ How to export a database from cPanel

  1. Log in to cPanel

    • Use the username and password you received when you signed up for hosting.

  2. Go to the "phpMyAdmin" section

    • It is usually found in the "Databases" group.

  3. Once inside phpMyAdmin:

    • You will see a list of databases in the left panel.

    • Click on the database you want to export.

  4. Then click on the "Export" tab (at the top).

  5. Choose the export method:

    • Quick (recommended if you do not need to customize anything).

    • Format: leave it as SQL.

  6. Click "Go".

  7. The .sql file will download automatically to your computer.

✅ How to export a database from DirectAdmin

  1. Log in to your DirectAdmin account

    • Use your panel access URL (for example, yourdomain.com:2222)

  2. Go to the "phpMyAdmin" section (also often found under "Advanced Tools").

  3. A new tab will open with the phpMyAdmin tool.

  4. In the left menu, select the database you want to export.

  5. Click on the "Export" tab at the top.

  6. Leave the "Quick" option selected and the format as SQL.

  7. Click "Go" and save the file.

📌 Useful tips

  • Export frequently, especially if you make regular changes to your site.

  • Store the files in a safe place and, if possible, off the server — such as your computer or Google Drive.

  • If your database is very large, use the "Custom" method to split it or exclude temporary tables.

  • Always verify that you are exporting the correct database if you have more than one.

🛠️ What if I want to export from a full backup?

If you are using the automatic backups available on your hosting (such as those available at Bacan.com), you can:

  1. Log in to your client area.

  2. Request the restoration or download of the database from a recent backup.