"Go" sqlite hint database disk image is malformed workaround

SQLite has a very serious disadvantage is not to provide repair command. Cause death Hint Database disk image is malformed it has many possibilities, such as insufficient disk space, and sudden power-down during writing data. Official explanation of the cause: Http://www.sqlite.org/lockingv3.html#how_to_corrupt

SQLite  My.sqlite3sqlite>pragma Integrity_check;

Get tips

In database main ***page 1518:btreeinitpage () returns error code 11On tree page 1566 cell 2:child Page depth differs On tree page 1566 cell 3:child page depth differssql error:database disk image is malformed

You can try a simple export import to reply to a damaged library file. Export Data First

Sqlite3 My.sqlite3sqlite>.output Tmp.sqlsqlite>.dumpsqlite>.quit

And pour it into a new library.

Sqlite3 Mynew.sqlite3sqlite>.read Tmp.sqlsqlite>.quit

The newly created Mynew.sqlite3 is generally available.

"Go" sqlite hint database disk image is malformed workaround