Mailing List Archive

Migrating an account to another dbmail instance...
hello folks,

I've been looking around for a solution/tool that will help me migrate
an account from one dbmail instance to another. What I want to achieve
is to migrate an account from one dbmail instance to another completely,
including ACLs, filters, auto-replies etc...

That being said, tools like imapsync doesn't help here. Also, both
dbmail instances have users already in-place, so using something like:

# create table export_users as select * from dbmail_users where
user_idnr = <IDNR>
# pg_dump --table=export_users --data-only --column-inserts dbmail >
export_users.sql

for all relevant tables would not work because of db key/id conflicts.

could someone point me to the right direction or shed some light on
this? I believe writing a custom tool would do the job, but really is
that the only option I have in this situation?

thanks
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Re: Migrating an account to another dbmail instance... [ In reply to ]
Am 14.01.2016 um 15:12 schrieb Chedomir Nikolikj:
> I've been looking around for a solution/tool that will help me migrate
> an account from one dbmail instance to another. What I want to achieve
> is to migrate an account from one dbmail instance to another completely,
> including ACLs, filters, auto-replies etc...
>
> That being said, tools like imapsync doesn't help here. Also, both
> dbmail instances have users already in-place, so using something like:
>
> # create table export_users as select * from dbmail_users where
> user_idnr = <IDNR>
> # pg_dump --table=export_users --data-only --column-inserts dbmail >
> export_users.sql
>
> for all relevant tables would not work because of db key/id conflicts.
>
> could someone point me to the right direction or shed some light on
> this? I believe writing a custom tool would do the job, but really is
> that the only option I have in this situation?

pretty sure impossible and you need to make that by hand

* imapsync
* re-create ACLs
* re-create filters
* re-create autoreplies

users end in different uid's, singlestorage of mimeparts and what not,
forget it on the db-level