[nmglug] webappsstore.sqlite with sqlite3?

akaluta akaluta at taosnet.com
Sat Apr 18 05:50:38 PDT 2009


Why can I not access the file?

a at radio:~$ cd ~/.mozilla/firefox/
a at radio:~/.mozilla/firefox$ echo 'select * from webappsstore;' | sqlite3
webappsstore.sqlite
SQL error near line 1: no such table: webappsstore
a at radio:~/.mozilla/firefox$ echo 'select * from webappsstore.sqlite;' |
sqlite3 webappsstore.sqlite
SQL error near line 1: no such table: webappsstore.sqlite
a at radio:~/.mozilla/firefox$ echo 'select * from webappsstore.sqlite;' |
sqlite3 webappsstore.sqlite
SQL error near line 1: no such table: webappsstore.sqlite
a at radio:~/.mozilla/firefox$ cd
~/.mozilla/firefox/qyjhls07.defaulta at radio:~/.mozilla/firefox/qyjhls07.default$ echo 'select * from webappsstore;' | sqlite3 webappsstore.sqlite
a at radio:~/.mozilla/firefox/qyjhls07.default$ ls  -al
total 32280
drwx------ 10 a a     4096 2009-04-18 06:27 .
drwx------  3 a a     4096 2009-04-18 05:56 ..
drwxr-xr-x  2 a a     4096 2009-04-17 18:13 adblockplus
-rw-r--r--  1 a a     2067 2009-04-17 17:14 blocklist.xml
drwx------  2 a a     4096 2009-04-17 18:08 bookmarkbackups
-rw-r--r--  1 a a     7139 2009-03-09 18:54 bookmarks.html
drwxr-xr-x  2 a a     4096 2009-04-18 06:40 Cache
-rw-------  1 a a   114688 2009-04-17 18:13 cert8.db
-rw-------  1 a a      442 2009-03-16 14:10 cert_override.txt
drwxr-xr-x  2 a a     4096 2009-03-09 18:54 chrome
-rw-------  1 a a      158 2009-04-01 05:35 compatibility.ini
-rw-r--r--  1 a a   154042 2009-04-17 18:13 compreg.dat
-rw-r--r--  1 a a     7168 2009-03-16 18:34 content-prefs.sqlite
-rw-r--r--  1 a a    18432 2009-04-18 06:25 cookies.sqlite
-rw-r--r--  1 a a    10240 2009-04-17 07:16 downloads.sqlite
drwxr-xr-x  7 a a     4096 2009-04-18 06:25 extensions
-rw-r--r--  1 a a     1093 2009-04-17 18:13 extensions.cache
-rw-r--r--  1 a a      944 2009-04-17 18:13 extensions.ini
-rw-r--r--  1 a a    19297 2009-04-18 04:20 extensions.rdf
-rw-r--r--  1 a a    10240 2009-03-12 08:15 formhistory.sqlite
-rw-------  1 a a    16384 2009-04-17 18:13 key3.db
-rw-r--r--  1 a a    17088 2009-04-18 06:27 localstore.rdf
lrwxrwxrwx  1 a a       15 2009-04-18 06:25 lock -> 127.0.1.1:+6723
-rw-r--r--  1 a a     5738 2009-04-16 06:54 mimeTypes.rdf
drwx------  2 a a     4096 2009-04-08 12:30 OfflineCache
-rw-r--r--  1 a a        0 2009-04-18 06:25 .parentlock
-rw-r--r--  1 a a     2048 2009-04-13 06:06 permissions.sqlite
-rw-r--r--  1 a a  2883584 2009-04-18 06:40 places.sqlite
-rw-r--r--  1 a a    62072 2009-04-18 06:40 places.sqlite-journal
-rw-------  1 a a     6358 2009-04-18 06:25 pluginreg.dat
-rw-r--r--  1 a a    44672 2009-04-18 06:25 prefs.js
drwxr-xr-x  2 a a     4096 2009-03-15 21:20 SDBackups
drwxr-xr-x  2 a a     4096 2009-04-18 06:25 SDThumbs
-rw-r--r--  1 a a     2048 2009-03-09 18:54 search.sqlite
-rw-------  1 a a    16384 2009-04-18 06:25 secmod.db
-rw-------  1 a a    12733 2009-04-18 06:25 sessionstore.bak
-rw-------  1 a a     9099 2009-04-18 06:27 sessionstore.js
-rw-------  1 a a      206 2009-04-13 06:07 signons3.txt
-rw-r--r--  1 a a 24944640 2009-04-18 06:26 urlclassifier3.sqlite
-rw-r--r--  1 a a      154 2009-04-18 06:25 urlclassifierkey3.txt
-rw-r--r--  1 a a     2048 2009-04-18 06:25 webappsstore.sqlite
-rw-r--r--  1 a a  2582805 2009-04-14 14:21 XPC.mfasl
-rw-r--r--  1 a a   107545 2009-04-17 18:13 xpti.dat
-rw-r--r--  1 a a  1829738 2009-04-18 06:25 XUL.mfasl
a at radio:~/.mozilla/firefox/qyjhls07.default$ 





More information about the nmglug mailing list