jasonc Posted May 27, 2006 Share Posted May 27, 2006 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. Quote Link to comment Share on other sites More sharing options...
fenway Posted May 27, 2006 Share Posted May 27, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.