> 50> > Crashed DB> > We lost some data when we were delivering our DB.> Can you recover it??> > Hint: SQLite> > [Download](https://0xd13a.github.io/ctfs/sharif2018/crashed-db/db0.db)
As the hint suggests we are dealing with a SQLite file. Let's try to open it:
```$ sqlite3 db0.dbSQLite version 3.21.0 2017-10-24 18:55:49Enter ".help" for usage hints.sqlite> .tablesError: file is not a databasesqlite> .dbinfounable to read database header```
The file is damaged. When we do a comparison with a valid SQLite database file we can see that the header is missing. We can copy it using any binary editor:
![missing header](https://0xd13a.github.io/ctfs/sharif2018/crashed-db/missing-header.png)
After the modification the database can be read:
```$ sqlite3 db0.db SQLite version 3.21.0 2017-10-24 18:55:49Enter ".help" for usage hints.sqlite> .tablestblsqlite> select * from tbl;0|S|ln?KxFjBA3o78Gv0!N&b|h|h0EdNc#L08Hn6a$AvNIux?(|a|uLsoz6Y|r|u9C#1cKQ3x@bWmk*JC|i|0P8Hy4Yc%g5Xzh...sqlite> .schemaCREATE TABLE tbl (Glaf varchar(15), Flag varchar(1), Lfag varchar(15));```
The database seems to be full of garbage, but notice the middle column. Not only it is called ```Flag``` it seems to contain the flag, one character per row:
``` sqlite> select group_concat(Flag,'') from tbl;SharifCTF{7d9ed4a5867f6bd376928a3ed7837a07}```
The flag is ```SharifCTF{7d9ed4a5867f6bd376928a3ed7837a07}```.