The Google page on uploading and downloading datastores is pretty useless, but I've gotten this far. Now I need to get the data in the .sql3 into whatever database it was originally stored in.
views:
31answers:
2
A:
Most likely this is for an SQLite database. Try looking at the documentation, it has info for how to create a database and load data into it.
speshak
2010-08-12 18:02:27
The result from downloading the datastore from GAE is in fact an sqlite database. The problem is that it appears that it needs to be processed by something else for it to be usable. Right now it contains two tables, results and bulkloader_database_signature. Is there some GAE program I need to run on my computer to get the database into a readable, usable format?
Teddy
2010-08-12 18:21:34
+1
A:
Assuming you're using the bulkloader's --dump functionality, it's not the intention that you directly access the downloaded sqlite database. Instead, you should restore it to an App Engine instance - either in production or on the dev-appserver - using the bulkloader's --restore flag.
Nick Johnson
2010-08-13 09:36:57
That clears a lot up:) I'm trying to get access to the database so that I can migrate it to a new RoR application. What do would you suggest for doing that?
Teddy
2010-08-13 18:46:41
Export the data as CSV or another format that you can read, and use that.
Nick Johnson
2010-08-14 18:37:40