On Wed, 17 Jan 2007 13:00:37 +0100, "Rocco Scappatura" <[EMAIL PROTECTED]> wrote:
>> Do you compact the database afterwards? >> >> Nigel > >No. How I have to do? > >rocsca From the CL use something like this: mysql -u root --password=<yourpassword> -e "USE spamassassin;OPTIMIZE TABLE awl, bayes_expire, bayes_seen, bayes_token, bayes_vars;" Your tables may differ slightly from mine, and some may have no content at all; initially try compacting the one that's biggest. KR Nigel