On 10/31/2010 10:18 PM, Jorge Bastos wrote: >>> Depends on what you need. I can't read your mind. If your not >>> comfortable writing sql and scripts, use dbmail-export. >> >> I'm testing the SQL query aswell... well both may work for me. >> Going to test them! >> > > Paul one thing I forgot to ask in the previous email: > > After deleting the records on dbmail_messages, we still have > dbmail_mimeparts and dbmail_partlists. > Will: > > /usr/local/sbin/dbmail-util -d -y > /usr/local/sbin/dbmail-util -p -y > /usr/local/sbin/dbmail-util -ty > > Take care of that job without problems? > > I'm just scared of damage something on the database.
In that case, do not delete the messages but set their status to 2, just like when you delete a message using POP3. That way dbmail-util will take care of the actual deletions. That will take two separate dbmail-util runs, so you can check for problems in between. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
