You can easily generate and download MySQL database backups anytime from the cPanel, by following these steps:
Step 1: Log into cPanel
Open your browser and log into your cPanel account by entering your username and password.
Step 2: Access the Backup Feature
Once logged in, navigate to the Files section on the cPanel dashboard. Click on Backup or Backup Wizard, both of which allow you to back up your database.
Step 3: Choose the Database Backup
If you’re using the Backup Wizard, choose the option to back up a specific part of your site. Under the Partial Backups section, locate the Download a MySQL Database Backup option. A list of databases will appear; select the name of the database you wish to back up.
Step 4: Download the Backup
After selecting the database, the backup process will begin automatically. Your browser will prompt you to download the .sql or .gz file. Save the backup file to your local computer.
This backup file can be used for future database restoration.