Paul J Stevens wrote: > > Ok, now the real work: > > find all unconnected physmessages that may have belonged to the deleted > user. > > - select id from dbmail_physmessage p left join dbmail_messages m on > p.id=m.physmessage_id where m.physmessage_id is null; > > - for each physmessage.id found thus create a new message: > > - insert into dbmail_messages (mailbox_idnr, physmessage_id) > values ($newuser_inbox_idnr, $physmessage_id) > Thank you Paul for you help.
By following your guide, and a little bit of PHP, I managed to salvage the messages from the ashes and behold, the emails. :p I like the idea of statuses for users, where dmail-users -d does not delete the user directly, but will be deleted by dbmail-util later. Great for cases of accidental deletion that have happened to me. Thanx guys for helping me out. ;) Regards, Daniel -- View this message in context: http://www.nabble.com/URGENT%3A-Accidentally-delete-mail-user-with-dbmail-users--d-tp24568228p24599349.html Sent from the dbmail users mailing list archive at Nabble.com. _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
