linux

[sqlite3] database disk image is malformed 나올때

Jadumate 2016. 1. 12. 19:20
728x90
반응형

sqlite3에서 database disk image is malformed 에러가 나올때... 

sql로 덤프한후 새롭게 DB구성



$ sqlite3  [망가진.db]


sqlite3> .mode insert

sqlite3> .output a.sql

sqlite3> .dump



$sqlite3 [new.db]


sqlite3> .read a.sql