Question Export Emails with details

[ToxicVerbid]

Hey guys,

Does anyone have or know a MySQL command to extract all e-mail address, passwords which then state the forwarder(s) and alias for the account?

 

[IgorG]

Try something like this

mysql> select mail_name,redirect,redir_addr,name,password from mail left join domains on mail.dom_id = domains.id inner join accounts where mail.account_id = accounts.id and postbox='true' order by name asc, mail_name asc;