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
