MyBackup v3.0.4

[orcking]

Now Backup:
Contacts,Bookmarks,SMS,MMS(attachments),AK Notepad,Settings,Home shortcuts and more..

[keshrad]

thanks a lot for this application

[shlongwoodian]

great app. so easy to just *boom, copy contacts/sms/mms, etc., *boom connect to PC and *boom, copy entire SD card (or card sans .MP3s 'cause ya probably already have those).

[harleyxlc]

Thank you!

[orcking]

you welcome..

[rivviepop]

Thanks, it's great! I'm still hoping you add the ability for us to name our backups (so we can back up each thing to it's own file!) - that would be stellar. Being able to backup SMS to it's own file separate from something that doesn't change like Settings sure would come in handy. This would also allow us to easily keep multiple backups on the SD card (i.e. contacts_20081223.xml, contacts_20081224.xml, etc.) so we can "roll back" if needed...

Any chance you have access to these apps' data to back them up?

K-9 (K-9 Mail)
ConnectBot
DroidFTP
StreamFurious

Thanks for listening.

[birdman81484]

Once backed up... is it possible to access this data on your pc? is there something out there that can interpret the data so it can be viewed. I need to put some text messages convo's online and want to know if it is possible to do it this way.

[rivviepop]

Once backed up... is it possible to access this data on your pc? is there something out there that can interpret the data so it can be viewed. I need to put some text messages convo's online and want to know if it is possible to do it his way.

It's in SQLite "format" so to speak; you need to use the SQLite tools to access it like a database (using SELECT statements and so forth). Here's a little program someone made to browse the data (I've not used it):

http://sqlitebrowser.sourceforge.net/

[birdman81484]

It's in SQLite "format" so to speak; you need to use the SQLite tools to access it like a database (using SELECT statements and so forth). Here's a little program someone made to browse the data (I've not used it):

http://sqlitebrowser.sourceforge.net/

I got it up and running and i can view the data... just need to figure out how to easily copy it to a text file.

[rivviepop]

I got it up and running and i can view the data... just need to figure out how to easily copy it to a text file.

Use the commandline tool that comes with the SQLite distribution called "sqlite3" (usually). Here's a sample, super simple session to save the output of the table "sms" to a text file, comma-delimited (done on Linux but it's the same on Windows or Mac):

$ sqlite3 358279012590087.xml
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> .mode csv
sqlite> .output data.txt
sqlite> select * from sms;
sqlite> .quit

See this page to download the tools (all platforms): http://sqlite.org/download.html

Using that tool you can mine the databases in any way possible by creating SQL queries as complex as you need (joining tables for instance), or you can just do it like the above example and spit it out into files and manually connect the dots - your choice.

Here's a SQL query that will cross reference the SMS data with the People and Phones data and spit out your SMS info that includes the person's name in your Contacts:

$ sqlite3 358279012590087.xml
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> .mode csv
sqlite> .output smsconversations.csv
sqlite> select people.name, sms.address, sms.thread_id, sms.body from people,sms,phones where people._id=phones.person and sms.address=phones.number;
sqlite> .quit

You can pretty much do any standard SQL query. Use ".tables" to see the table names, and ".schema <table_name>" to see the description of that table's columns. Put 'em together like Legos.