How to access sqlite database tables created by one-click Ghost installation on DigitalOcean?

October 6, 2014 3.1k views
akashdmukherjee
By:
akashdmukherjee

I created a droplet on DigitalOcean with one click Ghost installation. I know that the blog points to a sqlite database. But I am not sure how to access it. I also tried the sqlite3 command and it said that sqlite3 isn’t installed. Please advise

Log In to Comment
1 Answer
kamaln7 MOD October 6, 2014

You will need to install the sqlite3 package in order to use the sqlite3 command:

sudo apt-get install sqlite3

Then you can open your database with sqlite3:

sqlite3 /var/www/ghost/content/data/ghost.db
Reply
Have another answer? Share your knowledge.