To backup your MySQL database from phpMyAdmin on cPanel, follow these steps:
1. Log in to your cPanel account.
2. Click on the "phpMyAdmin" icon in the Databases section.
3. In the left-hand phpMyAdmin panel, click on the name of the database you wish to save, then click on the "Export" tab.
4. You'll have a choice of export methods. For a simple backup, you can generally use the "Quick" option with default settings. If you need advanced options, you can use the "Custom" option to customize the export parameters.
Export options (if you choose "Custom") :
-
- Select the tables to be exported.
- Choose the save format (SQL is generally used).
- Choose the type of insertion (INSERT, UPDATE, etc.).
- Select output method (download, save to server, etc.).
Once you've configured your export options, click on the "Export" button. This will start the export process.