More plesk mysql commands

To extract all the email information you need to recreate all mail accounts.

SELECT mail.mail_name,,accounts.password, mail.postbox, mail.redirect, mail.redir_addr, mail.mail_group,mail.autoresponder, mail.mbox_quota
FROM domains,mail,accounts
ORDER BY ASC,mail.mail_name ASC;

To extract all aliases

SELECT mail.mail_name,, mail_aliases.alias
 FROM mail, domains, mail_aliases
 WHERE mail.dom_id =
 AND = mail_aliases.mn_id;

Be the first to comment

Leave a Reply

Your email address will not be published.


This site uses Akismet to reduce spam. Learn how your comment data is processed.