Re: One Button DB backup

> On Nov 5, 2016, at 10:12 AM, 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. > > 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: I can download the entire database via phpMyAdmin — it’s quite simple — just export. I know I did it some time ago, but I can’t find the code. So, I was hoping someone had written a db export. In any event, thanks. Cheers, tedd