Mouse Posted July 19, 2006 Share Posted July 19, 2006 Dear all…Ok so I’ve just about got the PHP thing under control and the JavaScript (so I can learn Ajax next) is coming along… so the next thing I need to sort out is a bit of backing up of MySQL.Short of manually backing up my database each evening (hard to do as I am away a lot and the wife does like to see me occasionally) with a dump file via my host’s poor PHPMyAdmin, - or trusting them to do it correctly…Question:Is there a script / program / magic bit of hocus-pocus that will automatically back up my database and perhaps mail it to me every 24 hours or so?Answer: … over to you!Many thanksMouse Quote Link to comment Share on other sites More sharing options...
designationlocutus Posted July 19, 2006 Share Posted July 19, 2006 Look up Cron jobs :) Quote Link to comment Share on other sites More sharing options...
fenway Posted July 19, 2006 Share Posted July 19, 2006 Well, mysqldump will export your DB, but you have to write a script that will execute it... MySQL 5.1 has an event scheduler, though I've never used it. CRON is the way to go, for now. 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.