David Leinbach wrote:
> I didn't even know that script existed. I had written
something quite
> similar though to try and convert it but no luck with
the headers. I
The headers are not essential for a migration, they can be
reconstructed
using a single 'dbmail-util -by' run.
The core tables you need for a migration are:
dbmail_users
dbmail_aliases
dbmail_mailboxes
dbmail_messages
dbmail_physmessage
dbmail_messageblks
It's the dbmail_messageblks table that gives problems when
moving from
mysql to pgsql where it strands on encoding issues. If you
succeed in
migrating above tables, you should be home free.
> think I will try running the two imap servers side by
side and use
> imapsync and see if that works any better.
Yes. imapsync will migrate pretty much any imapserver to any
imapserver.
>
> Thanks
>
> On 7/21/07, Paul J Stevens <paul nfg.nl> wrote:
>> David,
>>
>> have you tried it following the example in
>> contrib/sql2sql/pgsql2mysql.sh ?
>>
>>
>>
>>
>> David Leinbach wrote:
>> > Hi,
>> >
>> > I have been running DBMail against a
PostgreSQL database for a few
>> > years now and have been pretty impressed.
However, in an effort to
>> > simply things, I would like to switch to MySQL
since I have to have
>> > MySQL for some of the other stuff I am running
but DBMail is the only
>> > thing on the PostgreSQL database. Has anyone
done this?
>> >
>> > I tried doing a straight SQL dump and insert
into the MySQL database
>> > but had issues with the message bodies and
headers now showing up.
>> >
>> > Thanks,
>> >
>> > David
>> >
_______________________________________________
>> > DBmail mailing list
>> > DBmaildbmail.org
>> > htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>> >
>>
>>
>> --
>>
____________________________________________________________
____
>> Paul Stevens
paul at nfg.nl
>> NET FACILITIES GROUP GPG/PGP:
1024D/11F8CD31
>> The Netherlands________________________________http://www.nfg.nl
>> _______________________________________________
>> DBmail mailing list
>> DBmaildbmail.org
>> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>
--
____________________________________________________________
____
Paul Stevens paul at
nfg.nl
NET FACILITIES GROUP GPG/PGP:
1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|
