I'm working (almost finished) actually on a python script that will
copy all data from one database to the other. This script can make
connections with both MySQL and PostgreSQL, where the "input" and
"output" systems can be of a different type.
Also, the script copies the data, without data loss on the original
side. It only copies from the DBMail 1.1 format to the DBMail 2.0
format.
Ilja
On Friday, Oct 10, 2003, at 13:31 Europe/Amsterdam, Mikael Syska wrote:
Hey,
Aint there a script for copying a Postgresql db to a mysql db, cause
its
kind a silly to both have a mysql and postgresql database when it all
can be
in the mysql, (have some other applications that runs on the mysql and
want
to have it all on the mysql if its possible to move all the data....)
// ouT
// Mikael
-----Oprindelig meddelelse-----
Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] På vegne
af
Roel Rozendaal - IC&S
Sendt: 10. oktober 2003 10:35
Til: DBMAIL mailing list
Cc: [EMAIL PROTECTED]
Emne: [Dbmail] php script for copying mailboxes to another db
hi all,
friend of mine worked this php-cmd line script out to migrate users
from one dbmail system to another. It has been used in production for
about 300 accounts with the sidenote that the dbmail daemons and
postfix were stopped - the script has explicitly not been tested for
usage in a system with running postfix and daemons.
You can specifiy the locations of the source and target system in the
code. It has some comments in it so it shouldn't be too hard to change
it to your own requirements.
Might be useful to some of yours, remember that your mileage may vary
:-)
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
