permissions.sqlite
Mac OS X Caminoで確認、FireFox3でも多分、同じ
cd 〓/Library/Application Support/Camino % sqlite3 permissions.sqlite SQLite version 3.6.12 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .output out.txt sqlite> .dump sqlite> .exit
out.txt修正は最後のINSERTの次番号から設定 INSERT INTO "moz_hosts" VALUES(135,'www.example.jp','cookie',8); の次に追加 INSERT INTO "moz_hosts" VALUES(136,'adv.livedoor.com','script',2); INSERT INTO "moz_hosts" VALUES(137,'adv.livedoor.com','document',2); INSERT INTO "moz_hosts" VALUES(138,'adv.livedoor.com','image',2); INSERT INTO "moz_hosts" VALUES(139,'adv.livedoor.com','object',2); INSERT INTO "moz_hosts" VALUES(140,'ard.yahoo.co.jp','script',2); INSERT INTO "moz_hosts" VALUES(141,'ard.yahoo.co.jp','document',2); INSERT INTO "moz_hosts" VALUES(142,'ard.yahoo.co.jp','image',2); INSERT INTO "moz_hosts" VALUES(143,'ard.yahoo.co.jp','object',2); INSERT INTO "moz_hosts" VALUES(144,'counter1.fc2.com','script',2); INSERT INTO "moz_hosts" VALUES(145,'counter1.fc2.com','document',2); INSERT INTO "moz_hosts" VALUES(146,'counter1.fc2.com','image',2); INSERT INTO "moz_hosts" VALUES(147,'counter1.fc2.com','object',2); INSERT INTO "moz_hosts" VALUES(148,'rd.yahoo.co.jp','script',2); INSERT INTO "moz_hosts" VALUES(149,'rd.yahoo.co.jp','document',2); INSERT INTO "moz_hosts" VALUES(150,'rd.yahoo.co.jp','image',2); INSERT INTO "moz_hosts" VALUES(151,'rd.yahoo.co.jp','object',2); INSERT INTO "moz_hosts" VALUES(152,'doubleclick.net','script',2); INSERT INTO "moz_hosts" VALUES(153,'doubleclick.net','document',2); INSERT INTO "moz_hosts" VALUES(154,'doubleclick.net','image',2); INSERT INTO "moz_hosts" VALUES(155,'doubleclick.net','object',2); INSERT INTO "moz_hosts" VALUES(156,'doubleclick.net','script',2); INSERT INTO "moz_hosts" VALUES(157,'doubleclick.net','document',2); INSERT INTO "moz_hosts" VALUES(158,'doubleclick.net','image',2); INSERT INTO "moz_hosts" VALUES(159,'doubleclick.net','object',2); INSERT INTO "moz_hosts" VALUES(160,'google-analytics.com','script',2); INSERT INTO "moz_hosts" VALUES(161,'google-analytics.com','document',2); INSERT INTO "moz_hosts" VALUES(162,'google-analytics.com','image',2); INSERT INTO "moz_hosts" VALUES(163,'google-analytics.com','object',2); INSERT INTO "moz_hosts" VALUES(164,'tracer.jp','script',2); INSERT INTO "moz_hosts" VALUES(165,'tracer.jp','document',2); INSERT INTO "moz_hosts" VALUES(166,'tracer.jp','image',2); INSERT INTO "moz_hosts" VALUES(167,'tracer.jp','object',2);
$ mv permissions.sqlite permissions.sqlite.backup
$ sqlite3 permissions.sqlite SQLite version 3.6.12 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .read out.txt sqlite> vacuum; sqlite> .exit
$ sqlite3 permissions.sqlite SQLite version 3.6.12 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .header on sqlite> select * from moz_hosts; 内容が表示される sqlite>.exit
参考:
セコメントをする