This shows you the differences between two versions of the page.
Next revision | Previous revisionLast revisionBoth sides next revision | ||
how_to:moving_messages [2011/09/30 16:42] – created paul | how_to:moving_messages [2011/10/03 09:01] – [Via Administrator Console] paul | ||
---|---|---|---|
Line 6: | Line 6: | ||
You can view a user's ' | You can view a user's ' | ||
+ | In version 5 you can view messages from folders other than the ' | ||
=====Via an email client===== | =====Via an email client===== | ||
This only works with VPOP3 Enterprise. | This only works with VPOP3 Enterprise. | ||
Line 14: | 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 will do it remotely as part of [[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 33: | ||
- 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' |