How to backup sqlite database?

by

The sqlite3 command line tool features the .backup dot command.

You can connect to your database with:

sqlite3 my_database.sq3

and run the backup dot command with:

.backup backup_file.sq3

Instead of the interactive connection to the database, you can also do the backup and close the connection afterwards with

sqlite3 my_database.sq3 ".backup 'backup_file.sq3'"

Either way the result is a copy named backup_file.sq3 of the database my_database.sq3.

It’s different from regularly file copying, because it takes care of any users currently working on the database. There are proper locks set on the database, so the backup is done exclusively.

More Related Contents:

  1. Version of SQLite used in Android?
  2. What are the performance characteristics of sqlite with very large database files? [closed]
  3. How do I backup a database file to the SD card on Android?
  4. Copying data from one SQLite database to another
  5. How can I merge many SQLite databases?
  6. How to retrieve the last autoincremented ID from a SQLite table?
  7. How to import load a .sql or .csv file into SQLite?
  8. How to recover a corrupt SQLite3 database?
  9. SQLite UPSERT / UPDATE OR INSERT
  10. SQLite insert speed slows as number of records increases due to an index
  11. Convert SQLITE SQL dump file to POSTGRESQL
  12. Limit an sqlite Table’s Maximum Number of Rows
  13. Sqlite in flutter, how database assets work
  14. Android: Where are database files stored?
  15. Can I download an SQLite db on /sdcard and access it from my Android app?
  16. Populate Android Database From CSV file?
  17. Populating Spinner From SQLite Database Android
  18. How to find SQLITE database file version
  19. Maximum number of rows in a sqlite table
  20. Predict next auto-inserted row id (SQLite)
  21. Backup/Restore a dockerized PostgreSQL database
  22. Database, Table and Column Naming Conventions? [closed]
  23. Relational table naming convention [closed]
  24. How to retrieve data from sqlite database in android and display it in TextView
  25. Database optimization orders
  26. What is database pooling?
  27. SQLite simultaneous reading and writing
  28. Storing a small number of images: blob or fs?
  29. Minimum no of tables that exists after decomposing relation R into 1NF?
  30. When we need to use 1-to-1 relationship in database design?

Leave a Comment