Web lists-archives.com

Re: [PHP] One Button DB backup




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.

If you can't use the shell (from inside PHP) to run the "dump" commands
for the DBMS involved, the last way I know is to use the SQL standard
"information_schema" view(s) to get at the schema for the database, and
then iterate over the results to fetch the individual table contents.

If you're looking for an off-the-shelf solution (push button, suck
data), I don't know one.

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