I am trying to compress the Mail database by running the sqlite3
vacuum command. But I get the following error:
SQL Error: file is encrypted or is not a database
I was running Mac OS 10.6 and I upgraded to 10.7. Now, it's running 10.7.4. I found that the Mail data folder is placed under the folder
~/Library/Mail/MailData on my machine.
So I use the following command:
sqlite3 ~/Library/Mail/V2/MailData/Envelope\ Index vacuum