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