Re: One Button DB backup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, Nov 06, 2016 at 10:00:33AM +0000, Chris Green wrote:

> Paul M Foster <paulf@xxxxxxxxxxxxxxxxx> 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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux