There are two popular ways to create a backup of your Joomla database. The first way is via the SSH console and the second way is to use the phpMyAdmin tool in your cPanel.You need to know your Joomla MySQL database name, password and username for either way.
First you need to access your account in order to create a backup of your Joomla database via SSH.Then navigate to your Joomla site folder. You need to use the information you’ve obtained from the configuration.php file and the mysqldump command to create a backup of your database. Then navigate your browser and download the backup of your Joomla database locally.
Login to your cPanel account and open the phpMyAdmin tool which is located in the Databases section. Then select the database you want to backup. The databases will be listed in the left menu of phpMyAdmin. Select your Joomla database and press the Export button from the top menu in phpMyadmin.Finally, leave the options to their default settings and press the Go button.