Results 1 to 5 of 5

Thread: Where are SQLite Databases Stored?

  1. #1
    Join Date
    Jan 2007
    Location
    New Rochelle, NY
    Beans
    62
    Distro
    Ubuntu 9.04 Jaunty Jackalope

    Where are SQLite Databases Stored?

    I installed SQLite from the repositories and I can't locate on the disk where the databases are created. Where is the default sqlite location and where are the database files stored?

  2. #2
    Join Date
    Apr 2008
    Location
    London
    Beans
    1,873
    Distro
    Kubuntu 12.04 Precise Pangolin

    Re: Where are SQLite Databases Stored?

    Run

    Code:
    sudo updatedb
    then run

    Code:
    locate sqlite
    As far as I can tell, the databases will mostly be stored in your /home folder.

    .

  3. #3
    Join Date
    Dec 2010
    Location
    Sometimes I visit earth
    Beans
    687

    Re: Where are SQLite Databases Stored?

    Quote Originally Posted by Sealbhach View Post
    Run

    Code:
    sudo updatedb
    then run

    Code:
    locate sqlite
    As far as I can tell, the databases will mostly be stored in your /home folder.

    .
    Maybe in a hidden folder?

  4. #4
    Join Date
    Apr 2008
    Location
    London
    Beans
    1,873
    Distro
    Kubuntu 12.04 Precise Pangolin

    Re: Where are SQLite Databases Stored?

    Quote Originally Posted by wep940 View Post
    Maybe in a hidden folder?
    locate will find them hidden or not. For example, here is a section of the results when I run locate sqlite

    Code:
    /home/vaio/.mozilla/firefox/e6h21bwc.default/content-prefs.sqlite
    /home/vaio/.mozilla/firefox/e6h21bwc.default/cookies.sqlite
    /home/vaio/.mozilla/firefox/e6h21bwc.default/downloads.sqlite
    /home/vaio/.mozilla/firefox/e6h21bwc.default/formhistory.sqlite
    /home/vaio/.mozilla/firefox/e6h21bwc.default/permissions.sqlite
    /home/vaio/.mozilla/firefox/e6h21bwc.default/places.sqlite
    /home/vaio/.mozilla/firefox/e6h21bwc.default/places.sqlite-journal
    /home/vaio/.mozilla/firefox/e6h21bwc.default/search.sqlite
    /home/vaio/.mozilla/firefox/e6h21bwc.default/signons.sqlite
    /home/vaio/.mozilla/firefox/e6h21bwc.default/urlclassifier3.sqlite

  5. #5
    Join Date
    Dec 2010
    Location
    Sometimes I visit earth
    Beans
    687

    Re: Where are SQLite Databases Stored?

    I've never used locate before, so I didn't know that. I'll keep locate in mind for the next time I'm driving myself nuts looking for something!

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •