sqliteRepair

A tool for repairing sqlite database

Environment

Windows 7(Production Env)

Python 3.6(Development Env)

How to use

Production Env

Step1

Directory Structure

├─RepairTool
│      dump.sql
│      read.sql
│      repairTool.exe
│      sqlite3.exe

Step2

Copy the corrupt sqlite database file to this directory.

Needed Files

├─RepairTool
│      dump.sql
│      read.sql
│      repairTool.exe
│      sqlite3.exe
│      CorruptDB

Step3

Open the command line in the current directory or use the cd command to this directory.

Then

D:\Tools\RepairTool>repairTool.exe CorruptDB NewDB

Param1: filename of the corrupt database file

Param2: filename of the new database file you want to export to

Step4

Example

D:\Tools\RepairTool>repair.exe CorruptDB NewDB
INFO: Starting reparing, please wait for a while.
INFO: DumpSql is successful.
INFO: Modify last line is successful.
INFO: ReadSql is successful.
INFO: Delete TempFile is successful.
INFO: Reparing is successful!

Now the files should be like this:

├─RepairTool
│      dump.sql
│      read.sql
│      repairTool.exe
│      sqlite3.exe
│      CorruptDB
|      NewDB

Development Env

Step1

cd to the code directory

cd <your directory>/code

Step2

Copy the corrupt sqlite database file to this directory.

Needed Files

├─code
│      dump.sql
│      read.sql
│      repairTool.py
│      sqlite3.exe
│      CorruptDB

Step3

use this command python repairTool.py CorruptDB NewDB