How to Backup a Database from phpMyadmin
1. Login in your cpanel and navigate the phpMyadmin
2. Select Database which you want to backup in
3. Select All tables which you want to backup
4. the radio button selection to the SQL option. The Structure and the Data check boxes should be checked.
5. After that click on GO button.
Now database dump file will start Downloading at your local computer.