Backing up the SQLite database in HTML5

Posted on 2011-10-27
Last Modified: 2012-08-14
In Google Chrome, selecting "Delete cookies and other site and plug-in data" also deletes the SQLite database that comes in HTML5.  This could be disasterous if someone has saved a lot of customer and salse data.  How can I back up this database, to restore it if someone does the above browser-history delete?

SQLite is designed to store all data in a single file.  So I'm hoping there is a standard name and place where this file is kept, and that I can simply copy it to replace if necessary.
Question by:RandyTommy
    LVL 13

    Expert Comment


    It is depend on where the plugin installed. For that in Chrome:
    1. Click on Wrench icon on Chrome toolbar
    2. Take Tools -> Extension
    3. Click on Plus icon next to Developer mode
    4. You can see the location of the plugin, most of file too in that location.

    Or you can use Process Monitor from Sysinternals to list any files used by Chrome and its plugin.

    Author Comment

    Hmmm.  Following the above path lead to the message:

    Boo... No extensions installed :-(

    I'm guessing that's because SQLite is being made a part of the HTML5 standard (which comes with Chrome) rather than an extention added later.
    LVL 13

    Expert Comment

    Then you need to dig deeper using Process Monitor.

    Maybe some other experts know exactly where the database is. Why not request of attention?

    Accepted Solution

    I beieve I have found my own answer, with a Google search.  It turned up a page at:
    which gives the location of the Chrome data for several operating systems.

    The database itself is in
    ....Chrome\User Data\Default\databases
    Looking up mine, I see each website has it's own database folder, named after the sites domain name.  For localhost, the folder is named
    unless you specify a port number (such as port 50213) which would produce the folder name

    Hopefully, all I need to do to backup my database is to save a copy of this one folder elsewhere.

    Author Closing Comment

    "B" grade, because the conclusion has not been completely tested.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    AWS Glacier is Amazons cheapest storage option and is their answer to a ‘Cold’ storage service.  Customers primarily use this service for archival purposes and storage of infrastructure backups.  Its unlimited storage potential and low storage cost …
    Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
    This tutorial will walk an individual through the process of upgrading their existing Backup Exec 2012 to 2014. Either install the CD\DVD into the drive and let it auto-start, or browse to the drive and double-click the Browser file: Select the ap…
    This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now