random1 Posted July 7, 2008 Share Posted July 7, 2008 Hey All, How do you run tasks (say backing up a database) at a certain time (say 1:00AM) on a schedule (say every morning, Mon-Fri)? I am running Windows XP with Apache, PHP, mysql. I know of 'Task Scheduler' for Windows and 'cron job' for *nix systems. Is there a better way of doing this, any PHP5 packages to recommend? Quote Link to comment https://forums.phpfreaks.com/topic/113506-scheduling-tasks-for-php-scripts/ Share on other sites More sharing options...
Lodius2000 Posted July 7, 2008 Share Posted July 7, 2008 its not php based that i know of all cron i dont know cron though but I know apache would be the one to back up a db every day Quote Link to comment https://forums.phpfreaks.com/topic/113506-scheduling-tasks-for-php-scripts/#findComment-583205 Share on other sites More sharing options...
CMC Posted July 7, 2008 Share Posted July 7, 2008 You could create a script that would dump your database, and then have that script run by a cron job at timed intervals. The system function mysqldump() can dump the DB info into a file for you and save it to a directory of your choosing (preferably out of access) That's what I do to backup my databases. http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html Quote Link to comment https://forums.phpfreaks.com/topic/113506-scheduling-tasks-for-php-scripts/#findComment-583235 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.