Program to read/edit android .db files on a PC?

Discussion in 'Motorola Droid 2 Global' started by seventieslord, May 18, 2011.

  1. seventieslord
    Offline

    seventieslord New Member

    Joined:
    May 16, 2011
    Messages:
    45
    Likes Received:
    0
    Trophy Points:
    0
    I've been having major SMS database problems following a backup and restore to my new phone. I can't delete messages or threads, Certain messages just won't restore, and some messages show as being received December 31, 1969. Also, sending and receiving are sporadic. These problems have persisted no matter what SMS program I use and no matter what program I use to back up from my old phone.

    However, I think I can solve this problem and share my solution with the world. All my messages are in my db file, even the ones that wouldn't restore to my new phone, and the ones that show up as December 31, 1969.

    My idea is to just delete all the records around the "problem date" (it seems to stall when restoring from July 31st, 2010 and stop there) as well as anything reading as 1969 and anything from short and unneeded threads, just for extra cleanup. My hope is that whatever is the source of the corruption will be gone, and the database will start to work properly again, adding and deleting records when requested.

    But I will die of old age before I get this done with SQLite db editor. Not that there's anything wrong with the software. But I would just have way too many records to individually delete. If I could see this on a computer screen, and even sort, highlight multiple records, etc, I could have this done in under an hour. But excel doesn't read these files, and I don't know what else I could try. Any suggestions?
  2. Gasai Yuno
    Offline

    Gasai Yuno New Member

    Joined:
    Apr 10, 2011
    Messages:
    758
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Rausu-cho
  3. seventieslord
    Offline

    seventieslord New Member

    Joined:
    May 16, 2011
    Messages:
    45
    Likes Received:
    0
    Trophy Points:
    0
    It looks like the best thing there, is a command line shell for windows. That would take me just as long as editing using the phone. I'm looking for something with a visual interface.
  4. Gasai Yuno
    Offline

    Gasai Yuno New Member

    Joined:
    Apr 10, 2011
    Messages:
    758
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Rausu-cho
Search tags for this page

.db editor

,
android .db file editor
,

android database editor

,
android edit db file
,
edit android db file
,
how to edit .db files android
,
how to modify .db files
,
how to open db file in android
,
how to read .db documents in android
,
how to view android files on pc
,
open android database file
,
open android db file
,
open db file android
,
open in a pc program .db android fils
,
read .db files