How to export a database backup in phpMyAdmin
Exporting a database gives you a downloadable SQL backup.
Steps
- Log in to cPanel.
- Open phpMyAdmin.
- Select the database you want to export.
- Click Export.
- Choose Quick for a standard export or Custom for more options.
- Choose SQL format.
- Click Export or Go.
When to export
- Before updating a website.
- Before changing plugins or themes.
- Before moving a website.
- Before making manual database changes.