*** 29,34 **** --- 29,41 ---- ------- Q) Is there a standard way of backing up SQlite databases aside from simply copying the database file to another location + + A) Yes. In the command line tool, the ".dump" command will output the schema + and data in the form of sql statements. E.g.: + + sqlite3 mydatabase .dump >Mybackup.sql + + You can pipe this file back into sqlite3 should you need to restore. ------ Q) Is it possible to output queries and associated results into an output text file? ------
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|