Thanks Steve, I think I am on the right way. It is a difference between the page sizes of the two databases. I have opened each database with Firefox SQLite Manager, and at the DB Settings I have seen a lot of differences, such as page size, Cache size, max page count etc. How can I Copy all these settings from the original DB to the clone. Is there a safe way, or I can only copy one by one, by querying and setting these Settings?
Thanks Steve Kallenborn wrote: > > Could there be a different page_size, resulting in differing amounts of > 'wasted' space? > > Check with "PRAGMA page_size;" or sqlite3_analyzer program. > > Thanks > Steve > > csabi81 wrote: >> I have made .dump for each database, original and clone, and saved into >> separated files. Than compare them. >> Differences are in INSERT INTO entries, in the clone database those >> entries >> are missing which I did not copy from the original. But the CREATE TABLE, >> CREATE INDEX, CREATE TRIGGER Commands are the same 100% >> > _______________________________________________ > 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-tp18827472p18846666.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