Jump to content


Photo

email-backing up all of the mysql databases - via a php file


  • Please log in to reply
1 reply to this topic

#1 jasonc

jasonc
  • Members
  • PipPipPip
  • Advanced Member
  • 841 posts

Posted 27 May 2006 - 10:57 PM

i wish to have all of the mysql databases emailed to me from a PHP file.

does anyone know how i do this for all of them.

i do not have any idea how to do it via the Cron jobs and i am using a windows server.


thanks for your help.



#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 27 May 2006 - 11:55 PM

First, you shouldn't ever e-mail anything a) large or b) sensitive, and I'd guess that DB dump qualifies as both. I'd recommend a (secure?) FTP site which you can run from anywhere, including your home machine. Windows doesn't support cron, but all server have AT scheduling capabilities -- I'm sure there are lots of tutorials out there. Ultimately, though, you'd be issuing a mysqldump, zipping/bundling the output, and sending it on its merry way. Depending on your db setup, you may have to lock the tables before taking a snapshot.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users