How to export a database in cPanel and DirectAdmin

Introduction

Exporting a database is useful when you want to create a backup, migrate your website, save a version before major changes or move information to another server.

The exported file is normally a .sql file containing the database structure and, depending on the chosen options, its records as well.

What exporting a database means

Exporting a database means creating a downloadable copy of its content.

That file can be used to:

1. Save a manual backup.
2. Migrate a website to another hosting service.
3. Restore information later.
4. Review data outside the server.
5. Keep a version before updating WordPress, Joomla or another application.

How to export a database from cPanel

1. Sign in to cPanel.
2. Open phpMyAdmin.
3. Select the database from the left menu.
4. Open the Export tab.
5. Choose the export mode and format.
6. Download the generated file.

How to export a database from DirectAdmin

1. Sign in to DirectAdmin.
2. Open the MySQL or phpMyAdmin access section.
3. Choose the database.
4. Open the Export tab.
5. Configure the export and download the file.

How to export a database from a full backup

In some cases, a full backup may also contain the database copy together with the website files, depending on how the backup is generated.

Useful tips

• Save the exported file in a safe place.
• Name the backup clearly with date and project.
• Make exports before major updates or migrations.

Frequently asked questions

Which format should I choose when exporting a database?

The most common and useful format is SQL.

Does exporting a database delete information from the hosting account?

No. Exporting creates a copy; it does not remove the original data.

Can I use this copy to migrate my website?

Yes, it is often part of the migration process.

How often should I export my database?

It depends on how often the website changes. Active projects benefit from more frequent backups.

Conclusion

Exporting a database from cPanel or DirectAdmin is one of the most useful maintenance and backup tasks you can perform for your website.