[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Backing up the SQLite database in HTML5

Posted on 2011-10-27
5
Medium Priority
?
938 Views
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.
0
Comment
Question by:RandyTommy
  • 3
  • 2
5 Comments
 
LVL 13

Expert Comment

by:khairil
ID: 37042857
Hi,

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.
0
 

Author Comment

by:RandyTommy
ID: 37044786
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.
0
 
LVL 13

Expert Comment

by:khairil
ID: 37049092
Then you need to dig deeper using Process Monitor.

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

Accepted Solution

by:
RandyTommy earned 0 total points
ID: 37056519
I beieve I have found my own answer, with a Google search.  It turned up a page at:
http://dev.chromium.org/user-experience/user-data-directory
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
http_localhost_0
unless you specify a port number (such as port 50213) which would produce the folder name
http_localhost_50231

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

Author Closing Comment

by:RandyTommy
ID: 37087260
"B" grade, because the conclusion has not been completely tested.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

829 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