Migration of squirrelmail data from old not ISPCONFIG server to new ispconfig 3 serv.

[isn]

I am migrating from an old server at godaddy in which did not have ISPconfig installed.

The new hardware has ISPconfig 3 installed and working pretty well.

My users, including <cringe> my wife have mail on old server.

Here is the layout of the squirrel folder $HOME/mail

[root@mercury mail]# ls -lartR
.:
total 160
-rw------- 1 daniel daniel 0 Apr 27 2006 inbox
-rw------- 1 daniel daniel 31 Oct 1 2007 .subscriptions
drwx------ 8 daniel daniel 4096 Oct 1 2007 .imap
-rw------- 1 daniel daniel 1683 Jun 15 2009 Drafts
drwx------ 6 daniel daniel 4096 Aug 16 06:55 ..
-rw------- 1 daniel daniel 106445 Nov 26 21:33 Trash
-rw------- 1 daniel daniel 0 Dec 28 14:43 salearn
-rw------- 1 daniel daniel 30294 Dec 28 15:01 spam
drwx------ 3 daniel daniel 4096 Dec 28 15:01 .
-rw------- 1 daniel daniel 0 Dec 29 09:43 Sent

./.imap:
total 32
drwx------ 8 daniel daniel 4096 Oct 1 2007 .
drwx------ 2 daniel daniel 4096 Jul 30 2008 Sent
drwx------ 2 daniel daniel 4096 Jun 15 2009 Drafts
drwx------ 2 daniel daniel 4096 Oct 27 17:47 Trash
drwx------ 2 daniel daniel 4096 Dec 7 13:34 INBOX
drwx------ 2 daniel daniel 4096 Dec 20 19:15 salearn
drwx------ 2 daniel daniel 4096 Dec 20 19:15 spam
drwx------ 3 daniel daniel 4096 Dec 28 15:01 ..

./.imap/Sent:
total 288
-rw------- 1 daniel daniel 5 Apr 27 2006 .customflags
drwx------ 8 daniel daniel 4096 Oct 1 2007 ..
-rw------- 1 daniel daniel 2576 Apr 23 2008 .imap.index.log
-rw------- 1 daniel daniel 6548 May 23 2008 .imap.index.tree
-rw------- 1 daniel daniel 171362 Jun 3 2008 .imap.index.data
-rw------- 1 daniel daniel 6816 Jul 8 2008 .imap.index
drwx------ 2 daniel daniel 4096 Jul 30 2008 .
-rw------- 1 daniel daniel 17428 Dec 23 22:22 dovecot.index.log
-rw------- 1 daniel daniel 47104 Dec 23 22:22 dovecot.index.cache
-rw------- 1 daniel daniel 12720 Dec 23 22:22 dovecot.index

./.imap/Drafts:
total 64
-rw------- 1 daniel daniel 1556 Apr 27 2006 .imap.index.tree
-rw------- 1 daniel daniel 2576 Apr 27 2006 .imap.index.log
-rw------- 1 daniel daniel 10264 Apr 27 2006 .imap.index.data
-rw------- 1 daniel daniel 5 Apr 27 2006 .customflags
drwx------ 8 daniel daniel 4096 Oct 1 2007 ..
-rw------- 1 daniel daniel 1608 May 28 2008 .imap.index
-rw------- 1 daniel daniel 708 Jun 15 2009 dovecot.index.log
-rw------- 1 daniel daniel 17408 Jun 15 2009 dovecot.index.cache
-rw------- 1 daniel daniel 240 Jun 15 2009 dovecot.index
drwx------ 2 daniel daniel 4096 Jun 15 2009 .

./.imap/Trash:
total 84
-rw------- 1 daniel daniel 5 Apr 27 2006 .customflags
drwx------ 8 daniel daniel 4096 Oct 1 2007 ..
-rw------- 1 daniel daniel 1940 Apr 22 2008 .imap.index.tree
-rw------- 1 daniel daniel 2576 Apr 22 2008 .imap.index.log
-rw------- 1 daniel daniel 12710 May 14 2008 .imap.index.data
-rw------- 1 daniel daniel 1992 May 14 2008 .imap.index
drwx------ 2 daniel daniel 4096 Oct 27 17:47 .
-rw------- 1 daniel daniel 17968 Nov 26 21:33 dovecot.index.log
-rw------- 1 daniel daniel 20480 Nov 26 21:33 dovecot.index.cache
-rw------- 1 daniel daniel 608 Nov 26 21:33 dovecot.index

./.imap/INBOX:
total 552
-rw------- 1 daniel daniel 16 Jun 3 2006 .customflags
drwx------ 8 daniel daniel 4096 Oct 1 2007 ..
-rw------- 1 daniel daniel 17156 Apr 21 2008 .imap.index.tree
-rw------- 1 daniel daniel 2576 Apr 21 2008 .imap.index.log
-rw------- 1 daniel daniel 206482 May 28 2008 .imap.index.data
-rw------- 1 daniel daniel 19032 Jul 9 2008 .imap.index
-rw------- 1 daniel daniel 131144 Jul 8 09:23 dovecot.index.log.2
drwx------ 2 daniel daniel 4096 Dec 7 13:34 .
-rw------- 1 daniel daniel 3416 Dec 23 22:21 dovecot.index
-rw------- 1 daniel daniel 69008 Dec 23 22:21 dovecot.index.log
-rw------- 1 daniel daniel 70656 Dec 23 22:21 dovecot.index.cache

./.imap/salearn:
total 80
-rw------- 1 daniel daniel 5 Oct 1 2007 .customflags
drwx------ 8 daniel daniel 4096 Oct 1 2007 ..
-rw------- 1 daniel daniel 1556 Apr 24 2008 .imap.index.tree
-rw------- 1 daniel daniel 2576 Apr 24 2008 .imap.index.log
-rw------- 1 daniel daniel 10264 Apr 24 2008 .imap.index.data
-rw------- 1 daniel daniel 1608 Jun 24 2008 .imap.index
-rw------- 1 daniel daniel 22528 Oct 27 17:46 dovecot.index.cache
-rw------- 1 daniel daniel 14392 Dec 20 19:15 dovecot.index.log
-rw------- 1 daniel daniel 200 Dec 20 19:15 dovecot.index
drwx------ 2 daniel daniel 4096 Dec 20 19:15 .

./.imap/spam:
total 140
-rw------- 1 daniel daniel 2576 Sep 21 2006 .imap.index.log
-rw------- 1 daniel daniel 5 Sep 21 2006 .customflags
drwx------ 8 daniel daniel 4096 Oct 1 2007 ..
-rw------- 1 daniel daniel 1556 May 10 2008 .imap.index.tree
-rw------- 1 daniel daniel 10264 May 10 2008 .imap.index.data
-rw------- 1 daniel daniel 1608 May 10 2008 .imap.index
-rw------- 1 daniel daniel 14624 Dec 20 19:15 dovecot.index.log
-rw------- 1 daniel daniel 79872 Dec 20 19:15 dovecot.index.cache
-rw------- 1 daniel daniel 600 Dec 20 19:15 dovecot.index
drwx------ 2 daniel daniel 4096 Dec 20 19:15 .


So question is. How do I get the data from old to new? Is there a squirrelmail utility?

If I wanted to store the mail in mysql, how would I handle that.

[isn]

Crude and ugly.

http://home.arcor.de/armin.diehl/imapcopy/imapcopy.html

This works.

Slow as in watching grass grow. Any reason why I let my wife pile up 50,000 messages in her spam folder?

DOH!

How about migration path to store this stuff in mysql ?

SEP