I created a table in SQLite and inserted few records. However I was unable to use the .backup command and keep getting the following error message: Error: cannot open testdatabase123.db
I noticed that the table that I created (see below) was not "saved" anywhere so when I exited out of SQLite and started it over again the table was nowhere to be found. CREATE TABLE TEST_USERS (USER_ID TEXT PRIMARY KEY, PASSWORD TEXT NOT NULL, IS_ADMIN INTEGER NOT NULL); Any idea where am I going wrong? Any help is appreciated. I am using SQLite version 3.6.12 on Mac OS X 10.6.8. Manish _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users