How To Create A New SQLITE DB From An Existing DB

Database has corrupted and none of the backups will work.
Can export data in DB to and TXT format file

***NOTE:  This should only be done under advisement from GWAVA Technical Support.  Any corruption or loss of data resulting from this procedure without consulting Support is at your own risk. Download and extract the sqlite.exe file from the following link http://www.sqlite.org/sqlite-3_5_8.zip Copy the DB to be exported to a Windows machine where the sqlite.exe file is located. To Export the data from the db to a text file, from a DOS prompt type: sqlite3.exe gwavaman.db .dump >gwavaman.txt To Import the data from the text file into a new gwavaman.db file, remove existing gwavaman.db from the Windows machine and type the following: sqlite3.exe gwavaman.db <gwavaman.txt This should take the contents of the gwavaman.txt and insert it's contents into an new gwavaman.db file

This article was originally published in the GWAVA knowledgebase as article ID 233.