how_to:moving_messages
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
| how_to:moving_messages [2011/10/03 08:56] – [Direct database access] paul | how_to:moving_messages [2011/10/03 08:59] – [Direct database access] paul | ||
|---|---|---|---|
| Line 15: | Line 15: | ||
| =====Direct database access===== | =====Direct database access===== | ||
| **Note that this is only for very advanced users, and we do not offer support for this method - if you mess up your message store, or lose messages because of doing this, that is your own responsibility**. If you want us to do this for you, then we are able to do it remotely as part of a [[http:// | **Note that this is only for very advanced users, and we do not offer support for this method - if you mess up your message store, or lose messages because of doing this, that is your own responsibility**. If you want us to do this for you, then we are able to do it remotely as part of a [[http:// | ||
| + | |||
| + | This method just allows you to move entire folders between users. | ||
| Note that the instructions below are for VPOP3 versions 3 to 5, and do not apply to earlier versions, and may change in later versions. | Note that the instructions below are for VPOP3 versions 3 to 5, and do not apply to earlier versions, and may change in later versions. | ||
| Line 30: | Line 32: | ||
| - If you want to move a single folder from the source user, and rename it for the target user: | - If you want to move a single folder from the source user, and rename it for the target user: | ||
| - type **SELECT folderid FROM messages.folders WHERE userid=//< | - type **SELECT folderid FROM messages.folders WHERE userid=//< | ||
| - | - type **UPDATE messages.folders set userid=//< | + | - type **UPDATE messages.folders set userid=//< |
| - [[Start VPOP3|Restart VPOP3]] | - [[Start VPOP3|Restart VPOP3]] | ||
| Do NOT skip the [[Backup VPOP3]] step - it is very easy to go wrong doing this, and you wouldn' | Do NOT skip the [[Backup VPOP3]] step - it is very easy to go wrong doing this, and you wouldn' | ||
| + | You may need to delete and re-create the IMAP account in the email client to have it load the new folders correctly (or have it reload all the folders if the email client supports that option - Outlook doesn' | ||
how_to/moving_messages.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1
Page Tools
