Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
howtos:sqliteutilitynotes [2007/01/23 00:24] texasfetthowtos:sqliteutilitynotes [2007/01/23 00:25] texasfett
Line 302: Line 302:
  
 <code>sqlite> .databases</code> <code>sqlite> .databases</code>
 +
  
  
Line 312: Line 313:
 A good way to make an archival copy of a database is this: A good way to make an archival copy of a database is this:
  
-<code bash>echo '.dump' | sqlite ex1 | gzip -c >ex1.dump.gz</code>+<code bash>echo '.dump' | sqlite ex1 | gzip -c >ex1.dump.gz</code>
  
 This generates a file named **ex1.dump.gz** that contains everything you need to reconstruct the database at a later time, or on another machine. To reconstruct the database, just type: This generates a file named **ex1.dump.gz** that contains everything you need to reconstruct the database at a later time, or on another machine. To reconstruct the database, just type:
 
howtos/sqliteutilitynotes.txt · Last modified: 2008/02/08 19:49 by 127.0.0.1
Old revisions

Should you find anything in the documentation that is incomplete, unclear, outdated or just plain wrong, please let us know and leave a note in the Documentation Forum.

Recent changes RSS feed Donate Driven by DokuWiki
The content of this wiki is protected by the GNU Fee Documentation License