pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: David Busby <busby@pnts.com>
To: Zavier Sheran <zsheran@yahoo.com>
Cc: pgsql-php@postgresql.org
Subject: Re: Backing up the database via browser
Date: Mon, 11 Nov 2002 09:52:43 -0800
Message-ID: <013301c289ab$2311feb0$4000000a@busbydev> (raw)
References: <20021110153627.83302.qmail@web14402.mail.yahoo.com>

Zavier,
    Using PHP You can do a ``, shell_exec, or passthru to run another
process, (search for the word "exec" on php.net).  Using that and PostgreSQL
command pg_dump you can pull it off, might take a while, here's some
untested code with no error checking

<?php
$db = $_GET['db'];
$cmd = "pg_dump -c -D -f /tix/miner/miner.sql -F p -N -U postgres $db";
$res = `$cmd`;
// Alternate: $res = shell_exec($cmd);
echo $res;
?>


----- Original Message -----
From: "Zavier Sheran" <zsheran@yahoo.com>
To: <pgsql-php@postgresql.org>
Sent: Sunday, November 10, 2002 07:36
Subject: [PHP] Backing up the database via browser


> Hi all,
>
> I'm looking for a way to create a link in a webpage
> that creates a backup of the database and another link
> to download the created backup file. Something similar
> to what phpPgAdmin uses in the "View dump (schema) of
> database" function with the "Structure and data"
> option selected. I browsed the source of phpPgAdmin
> but couldn't find the part where the code for that
> function is...
>
> Thanks for your help.
>
> -Zavier
>
> =====
> ---
> zavier.net - Internet Solutions
> ---
>
> __________________________________________________
> Do you Yahoo!?
> U2 on LAUNCH - Exclusive greatest hits videos
> http://launch.yahoo.com/u2
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster




view thread (3+ messages)  latest in thread

Message-ID: <013301c289ab$2311feb0$4000000a@busbydev>
Permalink:  ../013301c289ab$2311feb0$4000000a@busbydev/
Also on:    postgresql.org/message-id/013301c289ab$2311feb0$4000000a@busbydev

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: busby@pnts.com, zsheran@yahoo.com
  Subject: Re: Backing up the database via browser
  In-Reply-To: <013301c289ab$2311feb0$4000000a@busbydev>
  References: <20021110153627.83302.qmail@web14402.mail.yahoo.com> <013301c289ab$2311feb0$4000000a@busbydev>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox