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.)
***