Doesnt seem like that much data. you could do a sanity check and select the row counts from each table and use the where clause on the original. You could use the .output command selecting the data to different files (use an order by clause) then compare the two files. HTH
--- 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, 6:42 AM Thanks for Reply. I have tried VACUUM, nothing happens. The original database file remains the same size as before. What I create in the new database are Tables, Indexes and Triggers as well. I dont know if anything escapes from me. Mihai Limbasan 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 >> > You might want to try to VACUUM the original database to see whether the > file size is reduced on it as well. Please read the documentation on the > VACUUM command here: http://sqlite.org/lang_vacuum.html > > _______________________________________________ > 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-tp18827472p18829325.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
