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
Next revisionBoth sides next revision
how_to:moving_messages [2011/09/30 16:42] – created paulhow_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://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)]]
  
 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=//<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]]
  
how_to/moving_messages.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1