Дата публикации: Sep 14, 2019 7:27:38 AM
Владелец из dbmail_users - owner_idnr.
status=0 не прочитано, =1 - прочитано, =2 - удалено.
Устанавливаем статус, затем dbmail-util -dy
update
dbmail_messages m, dbmail_physmessage p, dbmail_mailboxes b
set
m.status=2
where
b.name = "INBOX"
and b.owner_idnr=1
and b.mailbox_idnr = m.mailbox_idnr
and m.physmessage_id=p.id
and p.internal_date < 2005-01-01;
#dbmail
Источник https://dbmail.dbmail.narkive.com/OtJZWdnd/query-to-delete-old-mail+&cd=4&hl=ru&ct=clnk&gl=ru
Подчистка частей, на которые нет ссылок
DELETE dbmail_partlists.* FROM dbmail_partlists LEFT JOIN dbmail_messages USING (physmessage_id) WHERE dbmail_messages.message_idnr IS NULL; DELETE dbmail_mimeparts.* FROM dbmail_mimeparts LEFT JOIN dbmail_partlists ON (dbmail_mimeparts.id=dbmail_partlists.part_id) WHERE dbmail_partlists.physmessage_id IS NULL; OPTIMIZE TABLE dbmail_partlists; OPTIMIZE TABLE dbmail_mimeparts;
Источник https://www.mail-archive.com/search?l=dbmail@dbmail.org&q=subject:"Re%5C%3A+%5C%5BDbmail%5C%5D+Db+growing+size"&o=newest&f=1