On 31 Oct 2009, at 3:22am, chen jia wrote: > Before I ran vacuum, this table, firmsret11, has 2338120 rows. > > After I ran vacuum as follows, > $ sqlite3 hq.db > SQLite version 3.6.10 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> vacuum; > sqlite> .exit > > and this table only had two rows, > $ sqlite3 hq.db > SQLite version 3.6.10 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> select count(*) from firmsret11; > 2 > > Dose anyone know how this could happen and how I can do to check what > is causing this problem? Thanks.
Please enter this line in the same sqlite3 tool you are using for vacuum: PRAGMA integrity_check; It appears that you have a copy of the database from before the 'vacuum' command. If you can, take another copy and run the PRAGMA command both before and after the 'vacuum'. For more details see <http://www.sqlite.org/pragma.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users