Sqlite doesn't delete data from the database the way you expect. It marks space as deleted and overwrites it later as needed. The "other records" are probably just deleted blocks.
Unless the VACUUM is deleting the 1 record, it hasn't reduced the file size too much. If the database is ACTUALLY corrupt (big if) nobody can help you, even this user group. More likely would be user error, or a bad delete by whatever app used this database. I would contact the company that makes that app and see what they can tell you. John -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of 1120.free Sent: Wednesday, October 21, 2009 4:19 AM To: sqlite-users@sqlite.org Subject: [sqlite] SQLite DB Structure Hi. I'm from Belarus. Sorry for my English. I NEED HELP! I have SQLite3 DB (contacts from iPhone), it contains 1 record, but when I open it with NOTEPAD.EXE, I see more than 1 record. I need to repair all records from it. Maybe it help: when I use 'VACUUM' command file size decreases too much. I attached file that I need to repair. If you can, extract lost data from it, please. It's VERY IMPORTANT for me. I don't know who can help me except you. -- С уважением, 1120.free mailto:1120.f...@gmail.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
