This article explains how to back up a MySQL database or selected tables using phpMyAdmin via cPanel. This method is useful when you need a full database backup or only want to back up specific tables for migration, troubleshooting, or data safety.
Steps to Back Up a MySQL Database or Tables Using phpMyAdmin:
- Log in to cPanel.
- Under the Databases section, click phpMyAdmin.
- In phpMyAdmin, click the Databases tab.
- Select the required database from the list.
- From the list of tables:
- Select all tables to back up the complete database.
- Or select only the specific tables you want to back up.
- Click the Export option from the top menu.
- Choose Custom under the Export Method to control what is included in the backup.
- Scroll down to the Output section and select the required compression format (optional).
- Review the selected tables and export settings.
- Click Export.
Once the process is complete, the selected database or tables will be downloaded to your computer in the chosen format.
Also Read: How to Repair a MySQL Database via cPanel