---
title: How to Export and Back Up a MySQL Database
description: "A database export protects website content, settings and transactional data. ## Export with phpMyAdmin 1. Open phpMyAdmin. 2. Select the database. 3. Choose Export. 4. Use Quick for a normal complete backup or Custom for advanced options. 5. Select SQL…"
url: "https://vertico.co.zw/docs/how-to-export-and-back-up-a-mysql-database/"
updated: "2026-07-23"
category: Hosting
---

# How to Export and Back Up a MySQL Database

A database export protects website content, settings and transactional data.

## Export with phpMyAdmin

1. Open phpMyAdmin.
2. Select the database.
3. Choose Export.
4. Use Quick for a normal complete backup or Custom for advanced options.
5. Select SQL format.
6. Download and store the file securely.

## Backup Frequency

- Before every major update.
- Before installing an unfamiliar plugin or module.
- Daily for frequently changing business systems.
- Before moving servers or changing database structure.

## Sensitive Data

 **Important:** Database backups may contain personal information and passwords. Store and transfer them securely.

## Need Help?

If you still need assistance, open a support ticket through your Vertico client account and include the affected domain or email address, a screenshot of the error, and the approximate time the problem occurred. Never send passwords by email or support ticket.