1. Log in to Cpanel
2. Goto MySQL databases -> phpMyAdmin (at the bottom of the page)
3. Select needful database in the left frame.
4. Click 'Export'
5. Select tables and backup options, 'Save as file' and click 'Go'.
6. Get the downloaded dump.