Hi,

I have migrated my data from old iredadmin 0.9.8 to 0.9.9 and done below steps mentioned on link:

1.copy all mailboxes (in Maildir format) to new iRedMail server with tools like rsync.
2.Set correct file owner and permission of mailboxes. Default owner is vmail, group is vmail, permission is 0700.

With SQL backends, you can get full maildir path of user with below SQL command:

mysql> USE vmail;
mysql> SELECT CONCAT(storagebasedirectory, '/', storagenode, '/', maildir) FROM mailbox WHERE username='user@domain.com';

after that I have updated mysql structure suggested here :

https://docs.iredmail.org/iredmail.releases.html

Version    Release Date    Upgrade tutorial    Comment
0.9.9    Dec 17, 2018    Upgrade from iRedMail-0.9.8    Contains SQL/LDAP structure change

https://docs.iredmail.org/upgrade.iredm … 0.9.9.html

https://docs.iredmail.org/upgrade.iredm … db-special

but I am  getting below error once I move vmail db to new iredadmin pro version and domains and migrated email ids not showing in domains and accounts option

Error: OperationalError(1054, "Unknown column 'maillists' in 'field list'")

Thanks