Skip to main content

How to Download a MySQL Database Backup

You can download a backup of a MySQL database directly from your cPanel account. This process allows you to save a copy of your database for local storage or for use during a manual migration.

You can download a backup of a MySQL database directly from your cPanel account. This process allows you to save a copy of your database for local storage or for use during a manual migration.

Before you begin

You will need:

  • A cPanel account

  • Access to the specific database you wish to back up

  • A local device to save the backup file

Download a MySQL database backup

  1. Log in to your cPanel account.

  2. Locate the Databases section and select phpMyAdmin.

  3. In the left-hand sidebar of phpMyAdmin, click on the name of the database you want to back up.

  4. Click the Export tab at the top of the page.

  5. Select Custom as the export method.

  6. Leave the other settings as default unless you have specific requirements for the output format (SQL is the standard format).

  7. Click Go at the bottom of the page.

  8. Your browser will automatically download the .sql file to your local device.

Confirm the result

  • The browser will initiate a download for a file ending in .sql.

  • You can verify the file exists in your local "Downloads" folder.

  • The file size should be greater than 0 KB.

If the export fails or is incomplete

If the export process is interrupted or the file is not generated:

  • Check that the database is not currently undergoing heavy write operations.

  • Ensure your local browser is not blocking the download of .sql files.

  • If the database is very large, the connection may time out; in this case, contact Hostek support to perform a server-side export.

Limitations

  • This process downloads a single database. To back up multiple databases or the entire cPanel account (including files and email), use the Backup tool in cPanel.

  • The size of the file you can download via phpMyAdmin is limited by your browser's maximum upload/download limits and the PHP execution time limits.

Did this answer your question?