sqlite3数据库损坏

[xt646449830]

Error: database disk image is malformed

提示如上，使用网上提供的方法，如下

sqlite> .output t.sql  
sqlite> .dump
sqlite> .quit
sqlite3 n.db
SQLite version 3.7.14.1 2012-10-04 19:37:12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .read t.sql; 
sqlite> .quit

无法修复，查看t.sql 如下

cat t.sql 
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE log(id integer primary key autoincrement,module varchar(32),module_china varchar(320),log_type int,log_time int,log_msg varchar(1024),log_msg_china varchar(10240));
/**** ERROR: (11) database disk image is malformed *****/
/**** ERROR: (11) database disk image is malformed *****/
CREATE TABLE log_flag(enable int);
/**** ERROR: (11) database disk image is malformed *****/
/**** ERROR: (11) database disk image is malformed *****/
/**** ERROR: (11) database disk image is malformed *****/
/**** ERROR: (11) database disk image is malformed *****/
ROLLBACK; -- due to errors

执行pragma integrity_check ，打印如下

pragma quick_check;
*** in database main ***
Page 4: btreeInitPage() returns error code 11
Page 3: btreeInitPage() returns error code 11
Page 2: btreeInitPage() returns error code 11
Page 5 is never used
Page 6 is never used
Page 7 is never used
Page 8 is never used
Page 9 is never used
Page 10 is never used
Page 11 is never used
Page 12 is never used
Page 13 is never used
Page 14 is never used
Page 15 is never used
Page 16 is never used
Page 17 is never used
Page 18 is never used
Page 19 is never used
Page 20 is never used
Page 21 is never used

[Oliver2891]

帮顶一下，我也遇到过文件损坏的问题，没解决掉。

[rucypli]

没修复工具就只能找备份了

[iihero_]

定期备份吧。

[看小雪]

cmd> sqlite3.exe database.sqlite ".dump" > sql.sql 我就是这样备份导出的，挺好用。我的博客数据以前也出现过类似于楼主的问题。也记录下来了关于这方面的问题呀，在博客里。 要多善于用google呀。

[rex1981]

备份很重要滴。。