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.