How do I backup a MySQL database using phpMyAdmin?

phpMyAdmin makes it easy to export (backup) your MySQL database as a single file that you can store locally or use to restore the database later.

Steps to Export Your Database

1. Log in to your cPanel account.
2. Navigate to the Databases section and click phpMyAdmin.
3. In the left-hand panel, click the name of the database you want to back up.
4. Click the Export tab at the top of the page.
5. Under Export method, choose one of the following:
   • Quick – Exports the entire database using default settings. Fastest option.
   • Custom – Lets you select specific tables, adjust settings, and choose compression.
6. If using the Custom method:
   • Select the tables you want to export (or leave all checked for the full database).
   • In the Output section, choose a compression format: zipped, gzipped, or none. Compressed files download faster and save disk space.
   • Under Format-specific options, you can adjust SQL compatibility if you plan to import into a different MySQL version.
7. Click Go (or Export) at the bottom of the page. The browser will download your database backup file.

Important Notes

• The export file will be an .sql file (or .sql.zip / .sql.gz if compressed).
• Store your backup in a safe, off-server location. Database backups stored on the same server are lost if the server fails.
• For large databases, use the Custom method with compression enabled to avoid timeouts during download.

Troubleshooting

• Download times out: If your database is very large, enable compression or contact your hosting provider about alternative backup methods such as SSH / command-line mysqldump.
• “No tables found” error: Ensure you selected the correct database in the left panel before clicking Export.