On 03/28/2011 12:16 AM, Jorge Bastos wrote:

> How can I restore an IMAP folder that contained some messages?

You can't.

> 
>  
> 
> Can I:
> 
>  
> 
> -          Create the folder again with the same name?
> 
> -          Set status for messages to 1 instead of 2 (update
> dbmail_messages set status=1 where status=2 and mailbox_idnr in (select
> mailbox_idnr from dbmail_mailboxes b join dbmail_users u on
> b.owner_idnr=u.user_idnr where u.userid='[email protected]'
> <mailto:u.userid='[email protected]'>);)
> 
>  
> 
> This will bring them back again?

That won't help. Message rows are connected to mailbox rows by cascading
key restraints. If you delete a mailbox (instead of moving it to
'trash') it is deleted from the database, taking all messages contained
therein with it.


-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to