Triggers are also copied. the original database has no views; anything escapes from me? any other parts of a database? It can be a problem because I manipulate Firefox3 sqlite databases, I am working on a small app which securely deletes some well known apps History, one of these apps is Firefox3. Its a project for my studdies. The problem is that after cloning one of the firefox databases it becomes corrupt or something, because Firefox seems not to work properly. So that is why I worried about size.
ken-33 wrote: > > I wouldn't be too worried about the size then if you have the indexes and > the data is there. > > How about triggers? Views etc? > > > > --- On Tue, 8/5/08, csabi81 <[EMAIL PROTECTED]> wrote: > From: csabi81 <[EMAIL PROTECTED]> > Subject: Re: [sqlite] Clone SQLite databases > To: sqlite-users@sqlite.org > Date: Tuesday, August 5, 2008, 1:47 PM > > Yes I have Indexes in original database, but I create them in the clone, > useing the SQL obtained from mastertable, as well as the TRIGGERS. > > > Stephen Woodbridge wrote: >> >> csabi81 wrote: >>> Hi everyone >>> >>> I want to clone a database: copy all data from original database to > the >>> destination database with a condition, so not all the entries need to > be >>> copied. I have tried the following: >>> Obtain SQL from mastertable and create the tables in the new database, >>> and >>> using INSERT to copy all data with a WHERE. My problem is that the >>> destination file size became very small; original was 160KB the >>> destination >>> is 55KB, I have deleted only a few entries. When I opened each > database >>> with >>> a SQLite Browser it seems everything OK, but I do not understand why > the >>> filesize became so small? >>> Am I loosing something to copy, or create? >>> >>> Tx for any help. >>> >>> P.S> sorry for my english :P >> >> Do you have indexes on the original DB that you have not added to the >> new DB? >> >> -Steve >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > > -- > View this message in context: > http://www.nabble.com/Clone-SQLite-databases-tp18827472p18837494.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Clone-SQLite-databases-tp18827472p18840065.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
