Database exporting

[AJ]

Hi all

As part of the CMS that I've written, I would like to give users the ability
to backup their own databases. Is there any way that this can be done with
PHP? What I'd like is for them to click a link and for it to create a txt
file and open the "Save as" dialog box so that they can save it off to their
hard drive.

Any help would be gratefully received.

Cheers

Andy

[Aphrael]

AJ wrote:

Hi all

As part of the CMS that I've written, I would like to give users the ability
to backup their own databases. Is there any way that this can be done with
PHP? What I'd like is for them to click a link and for it to create a txt
file and open the "Save as" dialog box so that they can save it off to their
hard drive.

Any help would be gratefully received.

Cheers

Andy

Look at PHPmyAdmin's code...

Aphrael...
--
"La demande mondiale d’ordinateurs n’excédera pas cinq machines."
(Thomas Watson, Fondateur d'IBM, 1945)

[Pieter Nobes]

AJ wrote:

Hi all

As part of the CMS that I've written, I would like to give users the ability
to backup their own databases. Is there any way that this can be done with
PHP? What I'd like is for them to click a link and for it to create a txt
file and open the "Save as" dialog box so that they can save it off to their
hard drive.

Any help would be gratefully received.

You have to options: you could use exec('mysqldump ') or the hardway (if
you're going to distribute your CMS this is the best mehod since your
not sure if you have access to exec() in PHP or mysqldump(8)) by
executing a SHOW TABLES, then looping trough those results and doing a
SELECT * FROM $table for each $tables as $table. It's not as simple as
it sounds since you also have to think about auto_increments , field
types (SHOW COLUMNS), PRIMARY KEYS, INDEXES, ...

--
Pieter Nobels

[Al C.]

AJ wrote:

Hi all

As part of the CMS that I've written, I would like to give users the ability
to backup their own databases. Is there any way that this can be done with
PHP? What I'd like is for them to click a link and for it to create a txt
file and open the "Save as" dialog box so that they can save it off to their
hard drive.

If you use a wrapper like ADODB (they changed the site for it so you have to
google for it) there is a function that will output a recordset (result from
an SQL select) to a csv file. Another other option is to use the exec()
function and execute mysqldump. You can pass it a selection criteria and it
will only dump certain records from tables you choose.

We do BOTH on JAYA123. See the demo at link below. Go to Utilities/Edit
Settings, Make Backup and you will see the kind of results you can get.

Al Canton

Adams-Blake Company, Inc.
***
JAYA123 - the web-based total-office system for the
small biz. Order entry, billing, bookkeeping, etc. for $14.95
a month. Everyone says "It's cool as a moose!!"
See why at:http://www.jaya123.com ('ja-eye-ah' means
'victory' in Sanskrit.)
***