you can use .read to read the .dump file. .read <file> reads a file containing SQL statements and executes them .import <file> <table> import data from a CSV file <file> into table <table>
Since .dump writes the output as an executable SQL script, the opposite function is performed by .read --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Andrew Paullin >Sent: Friday, 25 August, 2017 22:06 >To: sqlite-users@mailinglists.sqlite.org >Subject: Re: [sqlite] Bug + Enhancement ideas > >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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
