How to Backup a Database (phpMyAdmin Export) Print

How to Backup a Database (phpMyAdmin Export)

1. Log in to cPanel.

2. Open phpMyAdmin.

3. On the left, select the correct database:

   1. If unsure, check your app config (e.g., WordPress wp-config.php).

4. Click the Export tab.

5. Choose export method:

   1. Quick (simple sites)

   2. Custom (recommended for reliability)

6. For Custom export:

   1. Format: SQL

   2. Enable: “Add DROP TABLE / VIEW” (optional but helpful)

   3. Compression: gzip (optional)

7. Click Export and download the .sql (or .sql.gz) file.

8. Store it safely and label it with:

   1. Domain/service

   2. Date/time

   3. Environment (production/staging)