sqlite3 my_database .dump | gzip -c | ssh foo "dd of=db_dump"

Technically .backup is better because it locks less and batches operations, rather than doing a bunch of selects in a transaction. Do you prefer slowly filling up local disk or locking all writes?