Hi,
I have allot, I mean, millions of lost records in the dbmail_headervalue
table.
About 72 million lost records, with dbmail-util it cannot handle it in a
workable time.
Is it safe to truncate the table, and dbmail-util -by it?
Thanks.
Am 14.12.2014 um 17:59 schrieb Jorge Bastos:
I have allot, I mean, millions of lost records in the dbmail_headervalue
table.
About 72 million lost records, with dbmail-util it cannot handle it in a
workable time.
Is it safe to truncate the table, and dbmail-util –by it?
yes and you should
So,
Truncate dbmail_headername;
Truncate dbmail_headervalue;
Dbmail-util -by
During this time only IMAP will compaint since it won't have headers to
show, but there's no problem to have IMAP users connecting during this time,
when the re-fill is finish, everything will look normal on imap
correct
keep in mind that header_cache_readonly = yes will prevent from adding
any headers again - i removed all, inserted the needed manually in
headernames and than rebuilt
got rid millions of records forever that way
Am 14.12.2014 um 18:10 schrieb Jorge Bastos:
So,
Truncate
Hum,
Fact is I have garbage in headername table also, i have things that ARE NOT
headers, but they are there (garbage!):
+--+
| headername |
+--+
|