Re: One Button DB backup

On Sun, Nov 06, 2016 at 10:00:33AM +0000, Chris Green wrote: > Paul M Foster <paulf@quillandmouse.com> wrote: > > On Fri, Nov 04, 2016 at 01:14:37PM -0400, Tedd Sperling wrote: > > > > > Hi gang: > > > > > > I am in need of a one-button backup of a database via a php script > > > > > > Anyone have any suggestions, comments, code? > > > > > > > What I like about SQLite is that it's generally a single file which can > > be copied out. As I recall, MySQL has a cluster of files which can be > > done the same way, if you can find which directory they reside in. > > PostgreSQL is a lost cause. The files are all in one place, but the > > names are weird. > > > You can't do that if the database is in use, you might well end up > with a corrupt database. I use it in circumstances where I can control access. SQLite isn't one I would normally recommend for multi-user access. But it's used quite successfully by programs like Firefox. Paul -- Paul M. Foster http://noferblatz.com http://quillandmouse.com