Reconstructing an archived SQLite3 database file

280 views Asked by At

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!

0

There are 0 answers