[PHP] Sweet PHP backup / dump function for MySQL database

2003-11-04 Thread René Fournier
Right now, I'm using phpMyAdmin to periodically backup/dump a client 
MySQL database to a textfile (from which one can simply restore the 
database if it ever got corrupted). I'm also working on a super-simple 
CMS for the client to use themselves. I would like the client to also 
be able to easily backup his web site's MySQL database to a textfile 
and have that textfile emailed to whatever address he specifies. Sort 
of a two step approach:

Enter email _
 Backup and send database  (click)
I imagine someone somewhere has written a very nice function for doing 
this, which might take a few parameters, such as database, destination 
email address, etc. The main thing is that the function include 
complete inserts, extended inserts, backquotes, etc.

Anyone have a sweet function like this they wanna share, and in so 
doing make the world a better place?  :-)

...Rene

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] Sweet PHP backup / dump function for MySQL database

2003-11-04 Thread CPT John W. Holmes
From: René Fournier [EMAIL PROTECTED]

 Right now, I'm using phpMyAdmin to periodically backup/dump a client
 MySQL database to a textfile (from which one can simply restore the
 database if it ever got corrupted). I'm also working on a super-simple
 CMS for the client to use themselves. I would like the client to also
 be able to easily backup his web site's MySQL database to a textfile
 and have that textfile emailed to whatever address he specifies. Sort
 of a two step approach:

 Enter email _
  Backup and send database  (click)

 I imagine someone somewhere has written a very nice function for doing
 this, which might take a few parameters, such as database, destination
 email address, etc. The main thing is that the function include
 complete inserts, extended inserts, backquotes, etc.

 Anyone have a sweet function like this they wanna share, and in so
 doing make the world a better place?  :-)

Easiest way to do this is an exec() call to mysqldump, then read the file
and include/attach it in the email.

Writing something to simulate mysqldump from within PHP would be a waste,
imo.

---John Holmes...

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php