Re: [sqlite] How do I backup sqlite data file
sqliteX active.db .dump > backup.sql Koji Namekata wrote: Hi, What is the most reasonable way to backup sqlite data file? When applications using that db file are stopped, simple file copy `cp active.db backup.db' works fine. But with long running applications, is it correct to assume asynchronous copy may result in inconsitent state of the db file, and if so, how do I backup it? Thanks in advance. -- Namekata Koji
[sqlite] How do I backup sqlite data file
Hi, What is the most reasonable way to backup sqlite data file? When applications using that db file are stopped, simple file copy `cp active.db backup.db' works fine. But with long running applications, is it correct to assume asynchronous copy may result in inconsitent state of the db file, and if so, how do I backup it? Thanks in advance. -- Namekata Koji