procedure for data export / import:

$ cp data.db data.db.bak
$ sqlite3 data.db
$ .output ./$table_name.sql
$ .dump $table_name
# edit $table_name.sql as required
$ drop table $table_name;
$ .read $table_name.sql