Hey, Just tried the pg_dump and now the data are in the mysql, but still version 1.2, but better than nothing it that works, will test it later today, when the users go home.
But when I try to migrate to dbmail 2.0 the exact same error, but if just it can't run on mysql I'm happy, then the script to update to 2.0 can come later... Dbmail rocks... Keep up the good work guys // ouT > -----Oprindelig meddelelse----- > Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > På vegne af Paul J Stevens > Sendt: 2. februar 2004 12:46 > 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....... > > Yes, I'm using Christian's script as a base. > > Ilja Booij wrote: > > Hi, > > > > Paul J Stevens wrote: > > > >> 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 > > > > Seems to be a very useful approach. I guess the slowness is not an > > issue if you only have to do it one. > > > >> > >> 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. > > > > I agree that an SQL-only solution is much better. If you're > working on > > such a solution, please update me on your progress. Have you seen > > Christian Warden's earlier update script? > > > > -- > ________________________________________________________________ > Paul Stevens [EMAIL PROTECTED] > NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > The Netherlands_______________________________________www.nfg.nl > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
