Web lists-archives.com

Re: [PHP] One Button DB backup




On 06.11.2016 at 13:51, Paul M Foster wrote:

> 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:
>>>
>>>> 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.

Note that SQLite3 has a backup API[1] which is not yet supported by the
PHP bindings, though.  There is already a respective feature request for
ext/sqlite3[2].

[1] <http://sqlite.org/backup.html>
[2] <https://bugs.php.net/bug.php?id=70950>

-- 
Christoph M. Becker

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