1). Below command will show you the mysql root user password in a Plesk server.
mysql -uadmin -p'cat /etc/psa/.psa.shadow'
2). So to dump a db just use the normal mysql dump command along with the above one
mysqldump -uadmin -p'cat /etc/psa/.psa.shadow' database_name > database_name.sql