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

[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,