One line export of plesk mysql data

From Ezee.co.uk

Simple Command

echo "select name from domains" | mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa | more

What this does is echo the sql statement which is piped to the actual mysql command, the output is then piped to more. The mysql command is as you would expect except for the bit surrounded by `back ticks`

What the back ticks do is cause the command within to be executed first and the output from that is put in the place of the command. After processing the back ticks the command would end up looking like this before execution.

echo "select name from domains" | mysql -uadmin -p mypassword psa | more

For more on back ticks