Curtis Maurand wrote:
Hello all,
I find this list to be incredibly helpful. Thank you all in advance
of my question.
I need to move my installation from the current server to another.
That could be accomplished by simply doing a mysqldump -u <user>
-p<pass> --database dbmail |mysql -u<user> -p<pass> -h <new server> dmail
That's known and been done and that's great, but I don't want to move
several GB of mail. I only want to transfer the user accounts,
mailbox structure and sieve scripts. Which tables do I need to copy
to the new server? I'm running 2.2.9 on the older machine and 2.2.10
on the newer unit.
Hi,
The main large table is the dbmail_messageblks, which stores the bulk of
the email- but this does rely on an up-to-date dbmail_messages,
dbmail_phymessage and lots of the other tables which are used for
caching I believe? I assume you wish to test your installation first? If
this is the case, you should be able to copy over everything except the
messageblk. Recreate the messageblk on the new server and run
dbmail-util to tidy up your installation.
By the way - you may find it faster to use the
mk-parallel-dump/mk-parallel-restore in the mysql tool kit -
http://www.maatkit.org/ than a single instance of mysqldump
HTH
SG
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
