Explore our sites

Stack Exchange
tour help
Tell me more ×
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. It's 100% free, no registration required.
up vote 0 down vote favorite

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 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 at 4:34
 
sqlite3's dump file is intended to recreate everything in an empty database. –  CL. Oct 24 at 8:31
 
@CL..then I want dump file which restores in existing file then? like SQLiteManager does? –  Java D Oct 24 at 8:42
 
Just delete the database file first. –  CL. Oct 24 at 9:12
show 3 more comments

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.