[ubuntu-uk] Editing .db files
pbulteel at bulteel.org
Wed Jan 5 22:01:03 UTC 2011
> Message: 1
> Date: Wed, 5 Jan 2011 17:20:51 +0000
> From: javadayaz <javadayaz at gmail.com>
> To: British Ubuntu Talk <ubuntu-uk at lists.ubuntu.com>
> Subject: [ubuntu-uk] Editing .db files
> <AANLkTimSk2TyEco2j-ihtAVupVTMg89tx3txDcDmtuzT at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
> My podcast app on my android phone- Google Listen, saves any user data,
> playlists etc as a .db file.
> Is there anything i can use to open this file and edit the contents? Also
> no options are available in the ubuntu universe i will also look at windows
> tools for this job.
I wouldn't doubt that it's a sqlite3 database.
once you're at the sqlite> prompt you can use .help (note it's dot help) to
find out what else you can do.
Then a little sql magic will get you what you need.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the ubuntu-uk