试用了几天的Chrome了,感觉不错,期待插件接口的开放...
最新的Chrome的下载地址是:
http://build.chromium.org/buildbot/snapshots/chromium-rel-xp/
今天无聊,顺便看了下Chrome的文件,路径在C:\Documents and Settings\你的用户名\Local Settings\Application Data\Google\Chrome\User Data\Default 下面,有个History文件.
用UE打开后发现是SQLITE文件,于是用SQLITE打开(下载地址:http://www.sqlite.org/sqlite-3_6_2.zip)
操作方法如下:
1)用sqlite3.exe打开History文件
2)用 .tables 命令可以看到有图中几个表,从名字我们可以看出有下载记录,书签,访问记录等等
3)用 .output starred.txt 把输出重定向到文件
4)用 .dump starred 把书签表导出
5)接着去找下starred.txt文件就OK了.
文件大致如下,熟悉sql的可以分析下结构(如type=2是文件夹,type=1/3是默认的,type=0是书签)
可以通过这个办法对书签进行分组管理等转换
1BEGIN TRANSACTION;
2
3CREATE TABLE starred (id INTEGER PRIMARY KEY,type INTEGER NOT NULL DEFAULT 0,url_id INTEGER NOT NULL DEFAULT 0,group_id INTEGER NOT NULL DEFAULT 0,title VARCHAR,date_added INTEGER NOT NULL,visual_order INTEGER DEFAULT 0,parent_id INTEGER DEFAULT 0,date_modified INTEGER DEFAULT 0 NOT NULL);
4
5INSERT INTO "starred" VALUES(1,1,0,1,'书签栏',12864879599272250,0,0,12864903712413875);
6INSERT INTO "starred" VALUES(2,3,0,2,'其他书签',12864879599273250,0,0,12864901410029375);
7INSERT INTO "starred" VALUES(29,0,3825,0,'Gmail',12864881762934500,1,5,0);
8INSERT INTO "starred" VALUES(30,0,438,0,'Google Reader',12864881840111125,3,5,0);
9INSERT INTO "starred" VALUES(31,0,3833,0,'Google Docs',12864881878751125,2,5,0);
10INSERT INTO "starred" VALUES(32,2,0,5,'Google',12864881893109125,0,1,12864898849435375);
11INSERT INTO "starred" VALUES(35,2,0,7,'Book',12864882141057000,3,1,12864891426123000);
12
13CREATE INDEX starred_index ON starred(id,url_id);
14COMMIT;
导入的方法也差不多,把用.import指令。熟悉sql命令的人都知道怎么弄了,用.help可以看到sqlite支持的命令
示例图:
ps:囧...该文章用CHROME写的..发布按钮按了无效...复制到IE7去发布了..
ps2:最新的
Chromium数据存在:Local Settings\Application Data\Chromium\User Data\Default 下,书签存在Bookmarks文件里面,不再存在History里面.
该文件格式如下:
1 {
2 "roots": {
3 "bookmark_bar": {
4 "children": [ {
5 "date_added": "12865419024859500",
6 "name": "Google",
7 "type": "url",
8 "url": "http://www.google.cn/"
9 } ],
10 "date_added": "0",
11 "date_modified": "12865419024859500",
12 "name": "\u4E66\u7B7E\u680F",
13 "type": "folder"
14 },
15 "other": {
16 "children": [ ],
17 "date_added": "0",
18 "date_modified": "0",
19 "name": "\u5176\u4ED6\u4E66\u7B7E",
20 "type": "folder"
21 }
22 },
23 "version": 1
24 }
25