Every now and again, we have a database that gets corrupt in the field (bad coding on our end, not sqlite).
When we get one of these corrupt databases, we recover what we can by get one row at a time by rowid, like 'select * from mytable where rowid = 1' and we inc the row number every time. Each row we successfully recover we insert into a clean database. Works pretty well, except over time we've added more and more columns, each one that has to be pulled and bound to get it into the new table. We tried to do an 'attach' so we could do a 'select into' the clean database directly from the corrupt one. But as soon as we attempt to 'attach' the corrupt database, we understandable get a 'database is malformed' error. Is there an easier way to pull the good records out of a corrupt database and put them into a new one without binding each column by hand? Many thanks, Gene _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
