On 12 Jun 2018, at 11:20pm, skywind mailing lists <mailingli...@skywind.eu> wrote:
> when I load my database into sqlite3 and run an integrity check I only get > the error message: Error: database disk image is malformed > > I do not get any further information. What causes this simple error message? It means that there's no obvious cause. Which usually means that rather than a tiny detail being wrong (a single row pointer points to the wrong row) a big important thing is wrong (a page belongs to an index when it should belong to a table). However, this is often caused by the database not being closed properly. Which suggests the database was written on a small device with no warning of quit (e.g. mobile phone) rather than a computer with a 'Quit' command. So copy the database to a computer, and use the shell tool to make a trivial change to it, for example create a new table. Then quit the shell tool properly with ".quit". Then reopen the database and do another integrity check. Does it still report the same error ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
