Curtis Maurand wrote: > > I'm trying to move user accounts and mailbox structure without moving > the messages.
understood. Users will suddenly start seeing empty folders. very tricky. If you carefully setup all tables and dump/reload all tables *except* dbmail_messageblks you will avoid transferring the bulk of your data while retaining user experience. After setting up the new host users will start getting errors if the try to retrieve an /old/ message until you transfer the messageblks table as well. You must take special care to setup the auto-increment values correctly for the empty messageblks table. So use 'mysqldump -h oldhost -d dbmail|mysql -h newhost dbmail' if you ever mean to transfer the old email later on. I've never actually done this myself, but these migration scenarios are perfectly valid and deserve some exploratory experimentation, so please keep us informed :-) Of course if you don't mind if users suddenly start seeing empty folders you can also skip: | dbmail_ccfield | | dbmail_datefield | | dbmail_envelope | | dbmail_fromfield | | dbmail_headername | | dbmail_headervalue | | dbmail_mailboxes | | dbmail_messages | | dbmail_physmessage | | dbmail_referencesfield | | dbmail_replytofield | | dbmail_subjectfield | | dbmail_tofield | > I have bandwidth limits not the least of which is that > the current system is residing on a T1, is several GB in size (which > means hours to transfer) and I have bandwidth and diskspace limits on > the new host. > > Thanks, > Curtis > > Paul J Stevens wrote: >> 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. >>> >> >> Why? It's not obvious what you're trying to achieve here. >> >> >> > > > ------------------------------------------------------------------------ > > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
