how_to:moving_messages

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
how_to:moving_messages [2011/10/03 08:56] – [Direct database access] paulhow_to:moving_messages [2011/10/03 08:57] – [Direct database access] paul
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