Re: [Evolution] Documentation on SQL storage/import/convertion tools?

[Patrick O'Callaghan <poc usb ve>]

On Tue, 2010-07-20 at 12:32 +0200, Bruno PIGUET wrote:
>   For example, here is the listing on one of the folders (files ending
> with .index and .ev-summary have formerly been erased) :
>
> -rw-r--r-- 1 piguet tramm 5749825 2010-02-15 12:04
> mail_2009.sbd/liste-cf-metadata
> -rw-r--r-- 1 piguet tramm     208 2010-07-20 12:23
> mail_2009.sbd/liste-cf-metadata.cmeta
> -rw------- 1 piguet tramm   23317 2010-02-15 12:04
> mail_2009.sbd/liste-cf-metadata.ev-summary-meta
> -rw------- 1 piguet tramm       8 2009-06-08 09:08
> mail_2009.sbd/liste-cf-metadata.ibex.index.data

I'm almost certain you can also delete the .cmeta and .index.* files and
Evo will rebuild them. Take a backup just in case.

You can also rebuild the SQL indices as follows:

$ cat ~/bin/Vacuum
#!/bin/sh

cd ~/.evolution/mail/
for i in `find . -name folders.db`
        do
        echo "Rebuilding Table $i"
        sqlite3 $i "vacuum;"
done

Again, any of this should always be done with Evo shut down.

poc