This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
how_to:moving_messages [2011/09/30 16:42] – created paul | how_to:moving_messages [2011/10/03 08:57] – [Direct database access] paul | ||
---|---|---|---|
Line 14: | Line 14: | ||
=====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:// |
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 30: | ||
- 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]] | ||