En la web de sqlite, en la sección de preguntas frecuentes, en el buscador pones "backup" y aparecen muchas entradas, eliges una y encuentras algo así:
Te dejo
el enlace para que le eches un vistazo.
Cita:
The "backup" method
The "backup" method makes a backup copy of a live database. The command syntax is like this: dbcmd backup ?source-database? backup-filename The optional source-database argument tells which database in the current connection should be backed up. The default value is main (or, in other words, the primary database file). To back up TEMP tables use temp. To backup an auxiliary database added to the connection using the ATTACH command, use the name of that database as it was assigned in the ATTACH command.
The backup-filename is the name of a file into which the backup is written. Backup-filename does not have to exist ahead of time, but if it does, it must be a well-formed SQLite database.
The "restore" method
The "restore" method copies the content a separate database file into the current database connection, overwriting any preexisting content. The command syntax is like this: dbcmd restore ?target-database? source-filename
|