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 <[EMAIL PROTECTED]> 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 >> > [email protected] >> > https://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 >> [email protected] >> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > _______________________________________________ > DBmail mailing list > [email protected] > https://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 [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
