Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I generated dump file from java using .dump command so my back-up is ready now I want to restore it to once again so can anyone help me how to restore?

In stackoverflow I got this but nothing restore from this..backup-and-restore-sqlite-from-disk-to-memory-in-java

so how to restore this file?

share|improve this question
Java has no .dump command. If you've used .dump, it was in the sqlite3 command-line tool, which has nothing to do with Java. – CL. Oct 23 '13 at 12:05
@CL..ya I generated dump file in sqlite3 but generated dump file does not containing "Drop Table if exist" statement as it was in the SQLite manager generated file so can you help me for this? – Java D Oct 24 '13 at 4:34
sqlite3's dump file is intended to recreate everything in an empty database. – CL. Oct 24 '13 at 8:31
@CL..then I want dump file which restores in existing file then? like SQLiteManager does? – Java D Oct 24 '13 at 8:42
Just delete the database file first. – CL. Oct 24 '13 at 9:12

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.