How to Back Up a MySQL Database Using phpMyAdmin

phpMyAdmin is a powerful database management tool built into cPanel. You can use it to export a MySQL database as a .sql file - a portable backup you can store locally or use to restore your site later.

Steps to Export a Database

1. Log in to cPanel and go to Databases > phpMyAdmin.
2. In the left panel, click the name of the database you want to back up.
3. Click the Export tab at the top of the page.
4. Choose your export method:
   • Quick - Exports the entire database with default settings. Suitable for most backups.
   • Custom - Lets you select specific tables, add drop statements, or adjust encoding options.
5. Set the format to SQL (this is usually selected by default).
6. Click Export.

Your browser will download a .sql file containing the full contents of your database.

Tips for a Good Export

• Use Custom mode and enable Add DROP TABLE if you plan to import this backup into an existing database - it ensures old tables are replaced cleanly.
• Name your file with the date, for example: mysite-db-2026-03-13.sql
• Store the file in a safe location, separate from your web server.

When to Use This

phpMyAdmin exports are ideal before WordPress updates, theme changes, or any situation where your database data might be affected. It's a fast, reliable way to get a snapshot of your data at any moment.

If you need help locating your database name or navigating phpMyAdmin, contact our support team - we're glad to help.