Let view how to backup joomla database using phpmyadmin
1. First, login to your cPanel account you can access domain/cpanel
2. Open the phpMyAdmin tool which is located in the Databases section.
3. Now, you need to select the database you like to backup in the left menu. You will get the actual name of your database from the configuration.php file in /public_html
4. Next, select your Joomla database and press the Export button from the top menu in phpMyadmin.
5. Then Press GO
You already have database downloaded on your PC!