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
Log in to your cPanel account.
Locate the Databases section and select phpMyAdmin.
In the left-hand sidebar of phpMyAdmin, click on the name of the database you want to back up.
Click the Export tab at the top of the page.
Select Custom as the export method.
Leave the other settings as default unless you have specific requirements for the output format (SQL is the standard format).
Click Go at the bottom of the page.
Your browser will automatically download the
.sqlfile 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
.sqlfiles.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.
