Hey both, Sounds really great, I'm really looking forward to the news migration scripts :-D
// ouT > -----Oprindelig meddelelse----- > Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > På vegne af Paul J Stevens > Sendt: 2. februar 2004 11:59 > Til: dbmail@dbmail.org > Emne: Re: SV: SV: SV: [Dbmail] Easiest way to transfer mails > from postgresql 1.x to mysql 2.x or 1.x does not matter....... > > Perhaps you should then first migrate from pgsql to mysql, > before moving > from 1.2 to 2.0: > > I once used: > > pg_dump --file=/var/tmp/dbmail-dump.pgdata --format=p --data-only > --inserts --no-owner --no-reconnect --no-privileges dbmail > mysql -f dbmail < /var/tmp/dbmail-dump.pgdata > > which is very slow, but should work in most circumstances (exotic > charsets are always a pain). > > Also, I'm working on a sql-only solution to be included in the debian > packages. I don't want to make the dbmail packages depend on python, > python-mysql, and python-pgsql just to convert if I can avoid > it. Also, > I want the conversion to be non-interactive, and in-place, that is > without resorting to different databases for dbmail1 and dbmail2. > > > > > Ilja Booij wrote: > > I'll do my best to get a completely working script this > week. Migrating > > from PostgreSQL to MySQL makes things a bit more > complicated, because > > you can't use a simple SQL-script for that. > > > > Ilja
