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 Link to comment https://forums.phpfreaks.com/topic/15024-automatically-back-up-my-database/ Share on other sites More sharing options...
designationlocutus Posted July 19, 2006 Share Posted July 19, 2006 Look up Cron jobs :) Link to comment https://forums.phpfreaks.com/topic/15024-automatically-back-up-my-database/#findComment-60433 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. Link to comment https://forums.phpfreaks.com/topic/15024-automatically-back-up-my-database/#findComment-60525 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.