4 ms·
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 b
by throwawaaarrgh 3y ago
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?