On 9/6/05, John Duprey <[EMAIL PROTECTED]> wrote: > > What I'd like is a safe binary copy. > > From a previous post, I have seen someone suggest this: > attach 'foo.db' as bar; > create table baz as select * from bar.baz; > detach bar; > If I wrapped this in a loop for all tables it would probably do the trick. > Can this be done from the sqlite3 cli or will it have to be done in code.?
I wrote a small C++ program to do it that way. I interrogated the master table to get the list of existing tables to copy. --- The Castles of Dereth Calendar: a tour of the art and architecture of Asheron's Call http://www.lulu.com/content/77264
