I'm using the method described under the heading Converting An Entire Database To An ASCII Text File on this page to archive a sqlite3 database file.
Archiving the database file works fine:
$ echo '.dump' | sqlite3 store.db | gzip -c >store.dump.gz
Following the instructions on that page (though using gzcat
instead of zcat
), I try and reconstruct the archive into a database as follows:
$ gzcat store.dump | sqlite3 store_new.db
This executes, and store_new.db
is created, but it is a Zero KB file. What am I doing wrong?
(I'm using SQLite 3.7.13 on OS X.)
––––––––––––––––––––––––––––––––––––––
UPDATE:
Even doing a direct sqlite3 -> sqlite3 dump:
echo '.dump' | sqlite3 store.db | sqlite3 store_new.db
Results in a Zero KB store_new.db file :-( Any help appreciated!