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.
email-backing up all of the mysql databases - via a php file
1 reply to this topic
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