On 7/13/16, S.Ajina <[email protected]> wrote: >> To fix this, use the same mechanism for both output and input: >> >> sqlite3 old.db .dump > dump.sql >> sqlite3 new.db < dump.sql > > Yes this has worked. We use the method of dumping and recreating to overcome > some database corruptions - often in the indexes. I presume doing it this > way as you suggest would still lose any corruptions.
You shouldn't be getting corrupt databases. I'd rather focus on figure out why that is happening. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
