sqlite exe : database file path has hyphen : "unknown option: -"

Question

I am new to SQLITE. I am trying to open a database through Sqlite3.exe shell. My database file path has hyphen in it.. on entering .open C:\Users\Admin\OneDrive - batch\db.sqlite3

i am getting below error

unknown option: -

can anyone help..

I tried double quote around path but in that case I am getting

Error: unable to open database

Thanks in advance..

score 0 · Answer 1 · answered Jan 15 '23 at 05:23

0

Have you tried providing path like that:

C:\Users\Admin\"OneDrive - batch"\db.sqlite3

answered Jan 15 '23 at 05:23

Avad

197
1
8

thanks for the reply. Its not working. Same response: unknown option: - – Varun Jain Jan 15 '23 at 06:42
It it possible to move your reseources from OneDrive to a local directory? – Avad Jan 15 '23 at 07:44

Varun Jain · Accepted Answer · 2023-01-22T13:34:42.537

0

changing

backward slashes to forward
adding double quotes worked...

below is the solution

.open "C:/Users/Admin/OneDrive - batch/db.sqlite3"

edited Jan 22 '23 at 13:34

answered Jan 22 '23 at 13:32

Varun Jain

1
3

sqlite exe : database file path has hyphen : "unknown option: -"

2 Answers2