Log into the Plesk panel and click on the 'Database' icon.



Click on the 'Export Dump' icon.



By default the file has a name, change it if you would like, and check the 'Automatically download...' checkbox.

It will go to your local downloads folder.