Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
howtos:sqliteutilitynotes [2007/01/23 00:24] texasfetthowtos:sqliteutilitynotes [2007/01/23 00:26] texasfett
Line 302: Line 302:
  
 <code>sqlite> .databases</code> <code>sqlite> .databases</code>
 +
 +
  
  
Line 308: Line 310:
 ==== Converting An Entire Database To An ASCII Text File ==== ==== Converting An Entire Database To An ASCII Text File ====
  
-Use the ".dump" command to convert the entire contents of a database into a single ASCII text file. This file can be converted back into a database by piping it back into <b>sqlite</b>.+Use the ".dump" command to convert the entire contents of a database into a single ASCII text file. This file can be converted back into a database by piping it back into **sqlite**.
  
 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