I have downloaded one of my entities from Google App Engine using the remote API and their appcfg.py script. Now I have a file that looks to be a mix of binary and text. (That is, I recognize words like create table and my field names, but the file is about 50% un开发者_运维问答printable characters.)
Now I would like to import that file (users.sqlite) into an sqlite database on my computer (Mac OSX), but I can't quite seem to figure out how to do so.
Sample (failed) transcript follows:
sqlite> .import users.sqlite users
Error: no such table: users
sqlite> .import users.sqlite
Error: unknown command or invalid arguments: "import". Enter ".help" for help
sqlite> .restore users users.sqlite
Error: cannot open "users.sqlite"
sqlite>
I've attached a screenshot of the first portion of my datafile (displayed in TextMate with "show invisibles" on) to show what I mean about mixed text & binary.
Any hints?
Thanks!
users.sqlite
is an SQLite database. Your data is stored in it as entities - serialized Protocol Buffers in App Engine's internal format - however. If you need to access your data directly, you're better off downloading it as CSV.
精彩评论