Cron Database Backup

[unplugged_web]

How do I use cron to back up the full database every 24 hours with partial backups done every 30 minutes? I then want the backup to either be added to me or be uploaded to a folder on the ftp server.Thanks

[Synook]

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).

[unplugged_web]

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.