bulk edit chrome history items

Question

I visit a website frequently and its domain has changed (from foo.com to foo-bar.com). My history is full of the old-domain entries, which is very annoying, because I get a lot of 404s. I wonder if it's possible to bulk edit urls in Google Chrome history?

Answer 1

Chrome stores it's local history in an SQLite file called History.

On Windows you can find this file here:

C:\Users\YOURUSERHERE\AppData\Local\Google\Chrome\User Data\Default

The OSX location of this file is (as per @fodma1's comment):

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

I grabbed the free SQLite browser from DB Browser for SQLite and opened the history file. In there is a table called urls, opening this lists all the historic URLs.

You can then edit each line manually one by one or run a small SQL script to change multiple entries.

This SQL script will work for you:

UPDATE urls
SET url = REPLACE(url,".foo.",".foo-bar.")
WHERE url LIKE "%foo%";