yes this is a missing piece in dbmail-util and should be done manually this time because this table had 80% of all recods here some weeks ago
Am 15.05.2012 17:08, schrieb leandro: > Hello, > am I wrong or there is no dbmail-util procedure to delete headervalues > no more connected to messages? > > After deleting some users directly from the dbmail_database and running > the dbmail-util -ay housekeeping utility, I noticed the > dbmail_headervalue table size remains pretty the same. > > If I run manually the query: > > select count(*) from dbmail_headervalue where id not in ( select > headervalue_id from dbmail_header ); > > I discovered a large number of no more connected header values. > > Almost the same if I check the headernames with the query: > > select count(*) from dbmail_headername where id not in ( select > headername_id from dbmail_header ); > > Leandro > > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
