Auto vacuum on mail.app database

Posted by kain Wed, 03 Sep 2008 10:42:00 GMT

As you probably know (this is an old trick) it’s possibile to speed up mail.app by vacuuming it’s database, which is created with sqlite.

There’s also a trick to perform an autovacuum on it, here’s how:

Quit mail.app then open a terminal and issue the following:

sqlite3 ~/Library/Mail/Envelope\ Index ".dump" > EnvelopeIndex.sql

Add

pragma auto_vacuum=1;

to the top of EnvelopeIndex.sql

rm ~/Library/Mail/Envelope\ Index
sqlite3 ~/Library/Mail/Envelope\ Index ".read EnvelopeIndex.sql"

Cannot delete directories on fat32 filesystem under leopard

Posted by kain Sun, 24 Aug 2008 15:19:00 GMT

FAT32 formatted drives can not handle unix permissions at all.

You can not do chown, chmod or any of that stuff. In particular, if a file was locked in windows, it will be read as having an immutable flag in OS X. The only way to change it is by mounting the drive in windows.

You must open a dos window from inside windows and type:

attrib -r -s c:\foldername

and hit enter.

If you have long folder names or ones with spaces in the name it gets a little tricky guessing at the dos name equivilant ~1 etc. If you can’t get the dos name on any folders then rename the folder to a 8 letter name first then run the attrib command. Afterwards when you boot back into leopard, the locked check marks will be gone.

From pperret http://discussions.apple.com/thread.jspa?messageID=7090349

Remove every file that a .pkg provides

Posted by kain Fri, 18 Jul 2008 09:57:00 GMT

lsbom  -f -l -s /Library/Receipts/package_here.pkg/Contents/Archive.bom  | (cd /; sudo xargs rm)