Get Chrome history from remote machine
Let's say you need to get the url you visited Friday at the office, but its Sunday and you're at home! First, ssh into the remote machine where you were browsing the internet. Second, locate the history file, on OSX its at:
Third, try to open the file with a text editor. DOH! Its a sqlite file! Fortunately you have sqlite on your machine so you can use
sqlite3 History at the command line. Fourth, type
.table to see what tables are available. Oh that doesn't work, you get an error that says
Error: database is locked. This is easy to overcome though, just make a copy of the history file.
cp History History.1 sqlite3 History.1 > .tables downloads meta urls downloads_url_chains segment_usage visit_source keyword_search_terms segments visits
Now you have access to the database. The url you want is definitely in the
urls table, you just have to use your sql skills to find it!