Jump to content

Cron Database Backup


unplugged_web
 Share

Recommended Posts

You write a small script in your favorite scripting language (or just PHP, since it has a nice mysql extension) which does the backup, however you want (e.g. lots of SELECT queries, then write everything to a text document), or you may be able to find such a script already made. Then you go into cron and schedule php /path/to/my/script.php to run (on a shared host, there should be some sort of interface for this, on a dedicated server, have a look at the cron manpage).

Link to comment
Share on other sites

You write a small script in your favorite scripting language (or just PHP, since it has a nice mysql extension) which does the backup, however you want (e.g. lots of SELECT queries, then write everything to a text document), or you may be able to find such a script already made. Then you go into cron and schedule php /path/to/my/script.php to run (on a shared host, there should be some sort of interface for this, on a dedicated server, have a look at the cron manpage).
Thanks for that.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...