User Tools

Site Tools


how_to:moving_messages

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
how_to:moving_messages [2011/09/30 16:42] – created paulhow_to:moving_messages [2018/11/14 10:45] (current) – external edit 127.0.0.1
Line 6: Line 6:
 You can view a user's 'Inbox' messages by clicking on the message count on the **Users** list, then select the messages, choose the target user, and press the **Move** or **Copy** button You can view a user's 'Inbox' messages by clicking on the message count on the **Users** list, then select the messages, choose the target user, and press the **Move** or **Copy** button
  
 +In version 5 you can view messages from folders other than the 'Inbox' folder, but only move them to the target user's Inbox. In earlier versions of VPOP3 you can only view & move messages from the 'Inbox' folder.
 =====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://www.pscs.co.uk/buynow/buy.php?item=MISCPHONE|chargeable support call (£20 + VAT)]]+**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 [[http://www.pscs.co.uk/buynow/buy.php?item=MISCPHONE|chargeable support call (£20 + VAT)]] 
 + 
 +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=//<sourceuser>// AND folder='<folder name>';** (note the folderid)       - type **SELECT folderid FROM messages.folders WHERE userid=//<sourceuser>// AND folder='<folder name>';** (note the folderid)
-      - type **UPDATE messages.folders set userid=//<targetuser>// WHERE folderid=<folderid from previous step>;**+      - type **UPDATE messages.folders set userid=//<targetuser>//,folder='<new folder name>' WHERE folderid=<folderid from previous step>;**
   - [[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't want to lose all your messages! Do NOT skip the [[Backup VPOP3]] step - it is very easy to go  wrong doing this, and you wouldn't want to lose all your messages!
  
 +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't)
how_to/moving_messages.1317397327.txt.gz · Last modified: 2018/11/14 10:44 (external edit)