1 Topic by cvcvelo

  • cvcvelo
  • Member
  • Offline
  • Registered: 2014-06-16
  • Posts: 150

Topic: Bulk addition of accounts and aliases

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

I am migrating some domains from another mail server to an iRedMail server. Both servers use Maildir format, so I think I can just rsync messages over, but what about accounts?

Some domains have dozens of accounts and hundreds of aliases. Is it possible to create these programmatically using MySQL? If so, are there any examples of command syntax?

Thanks!

----

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: Bulk addition of accounts and aliases

cvcvelo wrote:

Some domains have dozens of accounts and hundreds of aliases. Is it possible to create these programmatically using MySQL? If so, are there any examples of command syntax?

*) To create mail users, check file shipped in iRedMail: tools/create_mail_user_SQL.sh.
*) To create mail alias account, check this tutorial:
http://www.iredmail.org/docs/sql.create.mail.alias.html