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