If you are new to SQLite or have just downloaded the latest SQLite3 version of Command-prompt or Terminal based utility that you may have found that the Dot-command .open, when executed to open an existing SQLite database file, gives the following error,
Command : $ sqlite3 .open /Users/code2care/myDatabase.db
Error: unknown command or invalid arguments: "open". Enter ".help" for help
To troubleshoot let's look into the .help file,
Code2care-Mac-mini::~ code2care$ sqlite3 /Users/code2care/myDatabase2.db
SQLite version 3.7.13 2012-07-17 17:46:21
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .help
.backup ?DB? FILE Backup DB (default "main") to FILE
.bail ON|OFF Stop after hitting an error. Default OFF
.databases List names and files of attached databases
.dump ?TABLE? ... Dump the database in an SQL text format
If TABLE specified, only dump tables matching
LIKE pattern TABLE.
.echo ON|OFF Turn command echo on or off
.exit Exit this program
.explain ?ON|OFF? Turn output mode suitable for EXPLAIN on or off.
With no args, it turns EXPLAIN on.
.header(s) ON|OFF Turn display of headers on or off
.help Show this message
.import FILE TABLE Import data from FILE into TABLE
.indices ?TABLE? Show names of all indices
If TABLE specified, only show indices for tables
matching LIKE pattern TABLE.
.log FILE|off Turn logging on or off. FILE can be stderr/stdout
.mode MODE ?TABLE? Set output mode where MODE is one of:
csv Comma-separated values
column Left-aligned columns. (See .width)
html HTML <table> code
insert SQL insert statements for TABLE
line One value per line
list Values delimited by .separator string
tabs Tab-separated values
tcl TCL list elements
...
...
...
You would see that there is a .open command that exists in Help. It seems that it has been removed/deprecated.
Workaround/Solution
✌️ Simply open the Database file without the .open keyword.
Code2care-Mac-mini:~ code2care$ sqlite3 /Users/code2care/myDatabase.db
SQLite version 3.7.13 2012-07-17 17:46:21
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>
More Posts related to Android,
- Android : Execute some code after back button is pressed
- Android is starting optimizing... app 1 of 1
- How to change Android Button Color using xml attribute and programatically using java
- SQLite with Android Easy to Understand Tutorial that covers Select, Insert, Update and Delete
- How to make Android EditText not editable
- Make Android TextView Clickable like Buttons
- Unable to establish connection to adb : Android Studio Error
- Android Constant and Resource Type Mismatches Lint
- Android Shared Preferences API tutorial
- Fixing Android unknown error 961 while downloading app
- DDMS files not found hprof-conv.exe
- How to reset eclipse layout
- Android Developers Bluetooth Tutorial
- Android Studio Native typeface cannot be made error
- 21 Useful Android Emulator Short-cut Keyboard Keys
- Multiline EditText in Android Example
- How to screenshot on Android?
- JavaScript : redirect page to other url
- Unable to load VM from snapshot. The snapshot has been saved for a different hardware configuration
- How To Disable Landscape Mode in Android Application
- Change Title text for Android Activity using java code
- Android : Class file collision: A resource exists with a different case
- Android Emulator Soft Back button action using Computer keyboard
- Device not compatible error Android Google Play Store
- ERROR x86 emulation currently requires hardware acceleration. Intel HAXM is not installed on this machine
- java.lang.NoClassDefFoundError android.support.v4.content.LocalBroadcastManager
- Disable Fading Edges Scroll Effect Android Views
- Android : Unable to load VM from snapshot : Mac OS X Error
- Change Android EditText Cursor Height
- What is Android Toast.LENGTH_SHORT and Toast. LENGTH_LONG durations
- How to add border to Android TextView
- Remove ActionBar from Activity that extends appcompat-v7
- How to send SMS on Android Emulator
- Android RatingBar Example
- This Toast was not created with Toast.makeText() : Android RuntimeException
- Android Studio Ctrl Shift o auto import not working
- Android : Duplicate registration for activity com.example.abc
- ADT Installation Error: requires plug-in org.eclipse.wst.sse.ui
- Running Android Lint has encountered a problem NullPointerException Error
- Android Emulator] ##KBD: Full queue, lose event Error Logs
- Export aborted because fatal lint error were found
- Android Parsing Data for android-L failed Unsupported major.minor version 51.0 Error
- Android : Accidental Octal Lint Warning
- Android ListView turns Black or Flickers while Scrolling
- How to make a dummy phone call from Android Emulator device
More Posts:
- Facebook Thanks for stopping by! We hope to see you again soon. - Facebook
- Android EditText Cursor Colour appears to be white - Android
- Disable EditText Cursor Android - Android
- Connection Failed: 1130 PHP MySQL Error - MySQL
- SharePoint Managed Metadata Hidden Taxonomy List - TaxonomyHiddenList - SharePoint
- Execute .bin and .run file Ubuntu Linux - Linux
- Possible outages message Google Webmaster tool - Google
- Android : Remove ListView Separator/divider programmatically or using xml property - Android
- Unable to edit file in Notepad++ - NotepadPlusPlus
- SharePoint PowerShell Merge-SPLogFile filter by time using StartTime EndTime - SharePoint
- SQLite Error: unknown command or invalid arguments: open. Enter .help for help - Android
- JBoss stuck loading JBAS015899: AS 7.1.1.Final Brontes starting - Java
- Android Wifi WPA2/WPA Connects and Disconnects issue - Android
- Android Toolbar example with appcompat_v7 21 - Android
- ERROR x86 emulation currently requires hardware acceleration. Intel HAXM is not installed on this machine - Android