Aaron Stone wrote: > On Thu, Jul 5, 2007, Sergey Spiridonov <[EMAIL PROTECTED]> said: > >> Sergey Spiridonov wrote: >> >>> Export DBMail in a way suitable for incremental backup by standard >>> backup tools, also simplify RDBMBS and DBMail flavours migrarting/upgrading >> Dear DBMail developers, just curious, is there anything in my proposal >> which is worth further discussion and (may be) implementing? >> >> Do you think there is nothing to do in this area? >> >> Should I put this on wiki? > > dbmail-export will produce mbox files, and with the -s option you can give > an imap search string to narrow down the output. I've put some suggestions > in the man page about how to use this to make monthly dumps.
And if you need fully incremental backups to any mailbox format: use imapsync to copy mail to another server while both dbmail and the other server use a shared ldap tree for authentication and mail routing. That's how I would do it. > > As for migrating databases, Paul put a bunch of work into some mysql2pgsql > / pgsql2mysql scripts a while back, but they never quite worked right and > had lots of hackishness about them, and I believe have been dropped from > the code base. If someone wants to take on this project we would be more > than happy to encourage it! Heh, they're not *that* bad :-). They are still in the tree (contrib/sql2sql/) but indeed the mysql2pgsql route does not work properly due to encoding problems in the bytea messageblk data. Of course, the same principle as for incremental backups (imapsync) applies here as well. It's just that performance is so poor doing it like that. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
