So, I was trying to do the World Populations SQL Practice II in my terminal. This is the first project I try to do from my own terminal and I can’t seem to get it started. I have downloaded the files and the database is stored in db.sqlite, which I have already opened with DB Browser to check if everything was ok, and it was. As you can see from the image above, tho, I cannot import the database to sqlite3 in the terminal and I have no idea why. I have tried looking out for an answer online, but found none, so I hope you can help me here.
presumably you created a new empty db rather than opening your file
The only thing I did was moving the folder in which the db was into the sqlite3 folder. I have just eliminated the files and re-downloaded them to see if anything changed, but the problem remains.
You’re specifying a filename, db.sqlite, but are you specifying where that file exists? It’s not going to search your entire file system for a match, it’s going to open that file right here whether it’s there or not