Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I need to recover old history. Google Chrome only stores the last 3 months in the "History" file.

The rest is in the "Archived History" file. How can I view this older history?

share|improve this question
    
Here you go How open Archived History file –  TweakFix Apr 19 '12 at 15:24
    
what is this? shareware? from 2008? –  designparadise Apr 21 '12 at 11:00
    
Isn't SQLite free? –  TweakFix Apr 21 '12 at 15:14

3 Answers 3

up vote 6 down vote accepted

The History and Archived History files are in fact an SQLite databases.

You can open them using SQLite Database Browser or one of the many other programs that can open SQLite databases.

share|improve this answer
    
are you 100% sure? it says 'archived history' is not a sqlite file. have you tried it yourself? –  designparadise Apr 21 '12 at 10:56
    
yes, I opened both with SQLite Database browser. You may also try SQLite Manager, which is a Firefox plugin: addons.mozilla.org/en-US/firefox/addon/sqlite-manager –  w0lf Apr 21 '12 at 11:42
    
ok it's doing the same thing, 'probably not a sqlite..' -- should chrome be closed? on the firefox addon, it doesn't even show the file, should the file be named .sqlite ? –  designparadise Apr 21 '12 at 11:54
    
yep needed .sqlite at the end, then i realized what i needed wasn't yet archived and was still in history.... –  designparadise Apr 21 '12 at 13:08
1  
@designparadise yes, I think it's best to close chrome before opening the database. –  w0lf Apr 21 '12 at 19:55

History older than 90 days is stored in the Archived History sqlite database file. As with the Chrome install, the actual location of the actual sqlite file varies by operating system. Once it is located you may have to close Google Chrome to unlock the file then open it with your favorite sqlite data browser.

Windows XP

C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Google\Chrome\User Data\Default\Archived History

Windows 7 or Vista

C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\Default\Archived History

Mac OS X

~/Library/Application Support/Google/Chrome/Default/Archived History

Linux

~/.config/google-chrome/Default/Archived History

As of the writing of this comment the Archived History database has the following tables:

meta
urls
visits
visit_source
keyword_search_terms

To query the file by visit and URL

--- Code below finds visits between 01/01/2013 and 02/01/2013 
--- on a windows machine which explains the timestamp conversion   
SELECT 
visits.visit_time
, datetime(visits.visit_time/1000000-11644473600,'unixepoch','localtime')
, urls.url, urls.title
FROM visits
LEFT JOIN urls ON visits.url = urls.id 
WHERE visits.visit_time > (strftime('%s','2013-01-01') + 11644473600) * 1000000
AND visits.visit_time < (strftime('%s','2013-02-01') + 11644473600) * 1000000
LIMIT 100
share|improve this answer
    
The visit datatime format is based on the information from this SO question and specifically the information submitted by @Squiggly stackoverflow.com/questions/2141537/… –  Eric Kigathi Feb 25 at 19:11

Download ChromeHistoryView (freeware). Click "Options > Advanced Options". Point the tool to the location of your Archived History file.

The tool is made for Windows. If you don't have access to a Windows PC, never fear: I've found that it works fine in Wine, so you can also use it on Mac and Linux.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.