doveadm backup to local drive

[Terry Barnum]

> On Feb 15, 2016, at 11:43 AM, Terry Barnum <terrydop at gmail.com> wrote:
> 
> I'm trying to get doveadm to backup all users to a local drive without any luck.
> 
> $ sudo doveadm backup -A /Volumes/mail_bak/mailstore_backup/
> Error: User listing returned failure
> doveadm: Error: Failed to iterate through some users
> 
> The doveadm-backup man page has the instruction to make sure the iterate query matches the database layout but I'm not sure what that means.
> 
> If the user_query in dovecot-sql.conf.ext looks like this, what should the iterate_query look like?
> 
> user_query = \
>  SELECT '/opt/local/virtual/%d/%n/mail' as home, \
>  'maildir:/opt/local/virtual/%d/%n/mail' as mail, 501 as uid, \
>  501 as gid, concat("*:storage=", quota) AS quota \
>  FROM mailbox WHERE username = "%u" AND active = "1"
> 
> # Query to get a list of all usernames.
> iterate_query = SELECT username AS user FROM users

I didn't see my original email show up on the mailing list so I'm resending. To recap, is it possible to backup all users to a local drive with doveadm?

Thanks,
-Terry

Terry Barnum
digital OutPost
Carlsbad, CA

http://www.dop.com
800/464-6434