On Mon, 11 Apr 2005, Witold Czarnecki wrote: >rsync could be better.
Neither would do a good job if the database contents change while you're copying it. There be pain and corruption. The safest way to take a snapshot is to use the sqlite shell .dump command, and feed the output of that to another sqlite shell to recreate the database. Otherwise, you must ensure that the database file is NOT in use, and no rollback journal exists. > >Best Regards, >Witold > >>> >>> And is there a way to automatically replicate the database to a second >>> system? >> >> Copying the database file should give you an exact replica. >> > -- /"\ \ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \