oh, and also perhaps a ".import" command would be a good compliment to ".dump".
Just an idea... On Fri, Aug 25, 2017 at 11:02 PM, Andrew Paullin <andrew.paul...@gmail.com> wrote: > Hello SQLite Team, > > Thank you very much for such a great product. > > Here are a few Enhancement ideas: > > On page: > https://sqlite.org/cli.html > > in section 10, idea to add: > > sqlite3 db_good.db < corrupt_db_export.sql > > as an example of how to restore a database. > > Also perhaps mention about how this export file can end with > "ROLLBACK", which needs to be changed to "COMMIT" to work properly. > > Also, on page: > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > in my opinion the statement: > > "The current archive is only available to the list members." > > is a bug, and the preceding link should instead go to: > > http://www.mail-archive.com/sqlite-users%40mailinglists.sqlite.org > > as indicated on this page: > > http://www.sqlite.org/src/wiki?name=Bug+Reports > > Or, perhaps these archives are different, and I am unaware of such > differences, in which cases in my opinion an Enhancement could be made > to explain those differences. I recently signed up for the mailing > list, so perhaps once I can login to the first archives page the > differences will become clear to me. > > Just ideas :^) > > I searched the existing bugs, the documentation, and also other forums > like stackoverflow for the bug, though may have missed. > > Thank you again and best regards, > > Andrew Paullin _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
