Documentation Source Text

Check-in [2530eac4fe]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add a fragment for the ".dump" command in the cli.html documentation.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 2530eac4fe37f70cc658d927dab6ac8a31e333f7
User & Date: drh 2015-10-15 01:25:08
Context
2015-10-16
11:35
Fix a typo. "databse" to "database". check-in: eb3ea9a953 user: drh tags: trunk
2015-10-15
01:25
Add a fragment for the ".dump" command in the cli.html documentation. check-in: 2530eac4fe user: drh tags: trunk
2015-10-14
12:45
Add sha1sum and SQLITE_SOURCE_ID values for 3.9.0 to changes.in. check-in: 0b8a218c16 user: dan tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/cli.in.

676
677
678
679
680
681
682

683
684
685
686
687
688
689
in windows.  This will typically bring up a spreadsheet program to display
the CSV file.  That command only works as shown on Windows.  The
equivalent line on a Mac would be ".system open /work/dataout.csv".
On Linux and other unix systems you will need to enter something like
".system libreoffice /work/dataout.csv", substituting your preferred
CSV viewing program for "libreoffice".


<h3>Converting An Entire Database To An ASCII Text File</h3>

<p>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>sqlite3</b>.</p>

<p>A good way to make an archival copy of a database is this:</p>







>







676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
in windows.  This will typically bring up a spreadsheet program to display
the CSV file.  That command only works as shown on Windows.  The
equivalent line on a Mac would be ".system open /work/dataout.csv".
On Linux and other unix systems you will need to enter something like
".system libreoffice /work/dataout.csv", substituting your preferred
CSV viewing program for "libreoffice".

<tcl>hd_fragment dump</tcl>
<h3>Converting An Entire Database To An ASCII Text File</h3>

<p>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>sqlite3</b>.</p>

<p>A good way to make an archival copy of a database is this:</p>