How to repair crashed the SQLite Database. Repair crashed the SQLite Database. ¶ When encounter crashed SQLite DB, and cannot read any data completely. Only see the error message. There is one way that you can try it. The top part of the figure, we export data from the crashed database, The bottom part of the figure, we import data into a new database. Export Data The command is sqlite3 {filename; You are crashed database}, open the broken the database. Using .output tmp.sql, there has a dot before the output command. Please notice. This operation is indicated the data export to tmp.sql. Using .dump command after the data begin the export into tmp.sql. The progress time depends on your database size. Using .quit to leave sqlite3 after the export finish. Import Data Using the command, sqlite3 {new filename, your new the name of the database}. Here, create a new database. Using .read tmp.sql (You export old data