You need to check your file system.
When you run the shell doing this on a new, empty directory (this is using the
shell from the website)
sqlite3 mydb.ext
In another window you should NOT see anything.
then after doing .dump you should see a 0-length mydb.ext file appear.
.quit -- your zero-length mydb.ext should still be there.
How are you getting wal mode without asking for it?
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
________________________________
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Dennis Volodomanov [i...@psunrise.com]
Sent: Friday, June 29, 2012 9:19 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] An interesting (strange) issue with selects
To further confuse things:
I've deleted all files from that old folder. Then using the shell:
"sqlite3 mydb.ext" and ".dump" - shows the usual rubbish. The
interesting bit here now is that there is no "mydb.ext" file in that
folder (checked using a second command prompt), but there are
"mydb.ext-shm" and "mydb.ext-wal" files there! Once I ".quit" there are
no "mydb*.*" at all.
Perhaps my drive or fat are dying or something?
Dennis
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
