How to migrate Chrome saved searches from one user profile to another

I’ve been using Google Chrome’s multiple user feature instead of Google’s web multiple sign-in recently. I created a second user profile in Chrome and migrated my bookmarks using the built-in import/export tool to move the bookmarks to Firefox and back. The built-in tool didn’t migrate my saved searches though. To copy my saved searches to my new profile, I had to crack open Chrome’s SQLite database. Here’s how.

Quit Chrome.

Export from one profile

$ ln -nsf ~/Library/Application\ Support/Google/Chrome/Default/Web\ Data /tmp/default.webdata.db

$ sqlite3 !$
sqlite3 /tmp/default.webdata.db
SQLite version 3.7.14 2012-09-03 15:42:36
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .output /tmp/default.webdata.keywords.sql
sqlite> .dump keywords
sqlite>

$ grep -v '^CREATE TABLE ' /tmp/default.webdata.keywords.sql >/tmp/default.webdata.keywords.data.sql

Import to another profile

$ ln -nsf ~/Library/Application\ Support/Google/Chrome/Profile\ 2/Web\ Data /tmp/profile2.webdata.db

$ sqlite3 !$
sqlite> delete from keywords;
sqlite> .read /tmp/default.webdata.keywords.data.sql

sqlite>

Restart Chrome.