On Mac OS X, the path is usually ~/Library/Thunderbird/Profiles/xxxxxxxx.default/
http://www.mozilla.org/support/thunderbird/profile