Regarding: *How do I do that? I thought that simply using ".backup/.restore" will give me what I want, but it gives me a file in internal format. What I am trying to do is do make a text file which gives me all SQL command that was issued (CREATE TABLE and INSERT) than fix the particular CREATE TABLEu.
and then load this file back into the db. All this will be done in the console (command prompt) window. Do I need to use ".dump/.load" commands for that?* It does seem the ".dump" command in the sqlite command shell program does just what you're asking. The ".load" command, though, loads program extensions -- the ".read" command is the proper inverse of the .dump. Note that you only need to .dump/.read the table(s) you want to alter. http://sqlite.org/sqlite.html _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
