I recently needed to email everybody on my Plesk server. Traditionally I’ve done this by maintaining an “all@domain.com” list for each subscription but of course that requires constant maintenance.<\/p>\n
So instead I did a bit of searching, amended what I found (on the plesk forum I believe), and came up with this (which requires ssh access) –<\/p>\n
# log into mysql\r\nmysql -uadmin -p`cat \/etc\/psa\/.psa.shadow`\r\n\r\n# Once logged into mysql \r\nuse psa;\r\nselect concat(mail.mail_name,\"@\",domains.name) as address from mail,domains,accounts where mail.dom_id=domains.id and mail.account_id=accounts.id order by address INTO OUTFILE '\/tmp\/emailaddresses.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\n';\r\nexit\r\n\r\n# This will create a file \/tmp\/emailaddresses.csv, which you can email yourself as follows\r\n<\/span>mail me@domain.com < \/tmp\/emailaddresses.csv\r\n\r\n# and then delete the source file for good measure!\r\nrm \/tmp\/emailaddresses.csv -f<\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"I recently needed to email everybody on my Plesk server. Traditionally I’ve done this by maintaining an “all@domain.com” list for each subscription but of course that requires constant maintenance. So instead I did a bit of searching, amended what I … Continue reading