cp db.sqlite3 backup.sqlite3 echo .dump tablename |sqlite3 db.sqlite3 >old.sql vi old.sql # make changes, ensure pragma FOREIGN_KEYS=off; drop table before insert sqlite3 db.sqlite3 <old.sql