[Replicant] Extracting text messages the hard way since apps don't work. DUH! what one word messes up...

A. F. Cano afc54 at comcast.net
Wed Sep 1 20:13:36 UTC 2021


On Wed, Sep 01, 2021 at 03:46:21PM -0400, A. F. Cano via Replicant wrote:
> ...
> The schema on both phones is identical, so I figured if I dump the
> table:
> 
> > sqlite3 contacts2.db
> SQLite version 3.27.2 2019-02-25 16:06:06
> Enter ".help" for usage hints.
> sqlite> .output call-log.sql
> sqlite> .dump --preserve-rowids --newlines

Duh! I told it to dump the whole database.  This should have been:

sqlite> .dump --preserve-rowids --newlines calls

In that case it only dumps the calls table, albeit with the CREATE TABLE
and other commands.  I'll try next to import this new file into the new
contacts2.db

Augustine


More information about the Replicant mailing list