How to export a MySQL database

Introduction

Exporting a MySQL database lets you download a copy of its content. It is useful before making changes to a website, migrating a site or saving a manual backup.

Many websites, such as WordPress, Prestashop or Joomla, depend on a database. That is why, before touching tables or updating major plugins, it is a good idea to keep a copy.

Before you start

Before exporting:

1. Identify which database your website uses.
2. Access your hosting control panel.
3. Make sure you have local space to save the file.
4. Do not modify tables if you are not sure.
5. Also make a copy of the website files if you need a full backup.

How to export a MySQL database

Follow these steps:

1. Log in to your control panel.
2. Go to the MySQL or Databases section.
3. Open phpMyAdmin.
4. Select the database you want to export.
5. In the top menu, click Export.
6. Keep the default options unless you need a special configuration.
7. Click Go.
8. Wait for the download to start.

[Suggested image: screenshot of the “Export” button in phpMyAdmin]

Within a few seconds, a file containing the database copy will be downloaded.

Which format to choose

For most cases, the recommended format is SQL.

A .sql file allows you to restore the database later from phpMyAdmin or other compatible tools.

Quick export or custom export

Quick export

This is the easiest option. It uses the default values and works for most users.

Custom export

It lets you choose specific tables, compression, structure, data and other advanced options.

Use this option only if you know exactly what you need.

How to save the copy correctly

• Give the file a clear name.
• Include the date in the filename.
• Save the copy outside the hosting account.
• Do not publish the .sql file on your website.
• Protect the copy if it contains sensitive data.

Example filename:

backup-mydb-2026-06-30.sql

Useful tips

• Export the database before updating WordPress or Prestashop.
• Download the files as well if you need a full backup.
• Do not leave .sql copies inside public_html.
• If the database is very large, contact support before exporting.
• Confirm that the download completed correctly.

Common problems

The download is interrupted

This can happen if the database is very large or the connection fails. Try again or ask for help.

I do not know which database is mine

In WordPress you can check the wp-config.php file, where the database name appears.

phpMyAdmin shows many tables

That is normal. Each CMS creates its own tables to store content and settings.

Frequently asked questions

Does exporting a database modify my website

No. Exporting only downloads a copy; it does not change the data.

Can I restore that file later

Yes, as long as the file is complete and compatible with the destination server.

Do I also need to export the files

Yes, if you want a full website copy. The database does not include images, plugins, themes or uploaded files.

What does the WordPress database contain

Posts, pages, users, settings, comments and plugin data, among other elements.

Conclusion

Exporting a MySQL database from phpMyAdmin is a simple and very useful process before important changes. Save the file securely and remember that, for a full backup, you also need to copy the website files.