[ubuntu-uk] Editing .db files

Patrick Bulteel 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
> Message-ID:
>        <AANLkTimSk2TyEco2j-ihtAVupVTMg89tx3txDcDmtuzT at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
> Hi,
> 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
> if
> no options are available in the ubuntu universe i will also look at windows
> tools for this job.
> --
> Regards
> Javad

I wouldn't doubt that it's a sqlite3 database.

sqlite3  your.db

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...
URL: <https://lists.ubuntu.com/archives/ubuntu-uk/attachments/20110105/7677cc50/attachment.html>

More information about the ubuntu-uk mailing list