Hi there, I experienced data loss in one my tables after I execute vacuum command from sqlite3.
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. Best, Jia _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
