commandlinefu.com is the place to record those command-line gems that you return to again and again.
You can sign-in using OpenID credentials, or register a traditional username and password.
Subscribe to the feed for:
Crude, but works. Note for security, /data/ will be inaccessible unless your device has been *rooted*.
On the other hand, if a device has been rooted, its data is now wide open to anyone with a USB cable and the above "one-liner".
`adb` is one of the platform tools in the android SDK.
To get SMS messages:
adb pull /data/data/com.android.providers.telephony/databases/mmssms.db ; sqlite3 -batch <<EOF contacts2.db <CR> .header on <CR> .mode tabs <CR> select * from sms; <CR> EOF