csabi81 wrote: > 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? >
Why don't you simply copy the entire database file (in a transaction to prevent corruption) and then delete the records you don't want? This copy will have all the same pragma settings as the original. This could optionally be followed by a vacuum command to reclaim the now unused space. Note that a vacuum really does yet another copy of the database file. Dennis Cote _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
