Hi, I'm working on an app that uses a SQLite database, and I'm getting a table not found error when running it. Is there any way to manually browse the database to see what the problem is? (Something similar to phpMyAdmin maybe)

yup, use adb shell to drop to the shell, then locate the db in /data/data/package and run

Code: Select all

sqlite3 dbfile

this will bring you into the sqlite shell where .help will give you the information on commands.

Thanks alot! Hopefully I can figure out my problem now

Sorry to ask another question, but how and when do I export the database within the shell? Do i need to have a breakpoint after the data is entered and then start the shell?

I've tried using the '.dump' command, but it only shows:

Code: Select all

sqlite> .dump
BEGIN TRANSACTION;
COMMIT;
sqlite>

EDIT:
Actually I found out from here that you need to use /data/data/package/databases/data as the file, so nevermind