Hello,
I need to migrate all users and messages from one dbmail database to
another. Is there a graceful way of doing this? I have a machine that
needs to be decommissioned and have another existing machine that has
lots of horsepower and room to have these few users (about 40) moved to
it.
If you don't have dbmail users on the new machine yet, you can copy
the complete database.
If there are already users on the new machine, try an imap-copy.
Met vriendelijke groet,
Marc Dirix
Electronics Design
Graaf Wolter Hoenstr 2
6243 BE Geulle
The Netherl
imap-copy has the limitation that I use passwords for each individual
user account. Some are encrypted and therefore inaccessible. I do have
the dbmail database on the new machine. I'm trying not to have to set
up multiple instances of dbmail on the same machine or even a virtual
machine.
Hi,
1 - backup with mysqldump on the old machine
2 - rsync or ftp the dump file to the new machine
3 - stop mysql on the new machine
4 - delete the innodb file on the new machine to start with a clean Innodb file
5 - start mysql on the new machine
6 - restore the dump file
I don't know if this is
Curtis Maurand wrote:
>
> imap-copy has the limitation that I use passwords for each individual
> user account. Some are encrypted and therefore inaccessible. I do have
> the dbmail database on the new machine. I'm trying not to have to set
> up multiple instances of dbmail on the same machine o
Time to get busy on a script, methinks. I'll se what I can do. This
should be able to be done via perl and walking through the tables.
lastinsertid() is my friend. I'll see what I can come up with.
Curtis
Paul J Stevens wrote:
Curtis Maurand wrote:
imap-copy has the limitation that