On 4 Jul 2011, at 10:53pm, Alexey Pechnikov wrote: > sqlite> pragma integrity_check; > *** in database main *** > Page 5 is never used > Page 35 is never used > Page 67 is never used > Page 97 is never used
Use sqlite3 to dump your database to a file of SQL commands. Use sqlite3 to use that file of commands to create a new database. Run the integrity_check on the new database. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
