I need a command-line script running on Mac OS 10.5 to rebuild sqlite
3 database files with a page_size of 4096 bytes.
The first line of my script dumps the database to a text file, then
next line should read it create a new one. Since the default page
size is 1024 bytes, documentation says that I need to change it with a
PRAGMA before creating the database. So I do this:
sqlite3 newDatabase.sqlite 'PRAGMA page_size=4096; .read dump.txt'
Result:
SQL error: near ".": syntax error
If I eliminate either the PRAGMA or the .read statement, there is no
error. But I need them both. What can I do?
Thank you,
Jerry Krinock
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
