1 Topic by pbf343

  • pbf343
  • Member
  • Offline
  • Registered: 2013-05-30
  • Posts: 243

Topic: Alias mail list data in database

==== Required information ====
- iRedMail version (check /etc/iredmail-release):
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- Related log if you're reporting an issue:
====

Hello,
I need to recover some email addresses from a domain that was deleted.
    Domain => Aliases => List of member email addresses. 

Which database would this reside (? vmail) and table, etc.  Looking for this data in the backups.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Alias mail list data in database

pbf343 wrote:

Domain => Aliases => List of member email addresses. 

To check members of mail alias account, you should check SQL table "vmail.alias", column "alias.goto".

3 Reply by pbf343

  • pbf343
  • Member
  • Offline
  • Registered: 2013-05-30
  • Posts: 243

Re: Alias mail list data in database

ZhangHuangbin wrote:
pbf343 wrote:

Domain => Aliases => List of member email addresses. 

To check members of mail alias account, you should check SQL table "vmail.alias", column "alias.goto".

Thank you but would that data be in the backup cron jobs that run in mysql?  The domain was incorrectly removed and want to recover the members under the alias.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Alias mail list data in database

Of course you can recover it from your SQL backup file.