Anisa said:
Gerhard Killesreiter wrote:
No cron jobs no automatism.
You could write a script that is executed through cron.php though and
use poormanscron.
Aw. I can actually run cron jobs on my server, I just need to read up
more.
Then I would suggest to set up a normal cronjob using a simple shell script and mysqldump (or any other simulare util for your database). ----- #!/bin/sh # # Backup script for a MySQL databases. # if [ -z $1 ]; then echo "usage: $0 databasename"; exit 1; fi
# Change to your backup place OUTPUTDIR=/tmp
TODAY=`date +%Y-%m-%d` mysqldump --defaults-file=backup.cnf $1 > $OUTPUTDIR/$1_$TODAY.sql
# You can use this instead to compress the file on the fly # mysqldump --defaults-file=backup.cnf $1 | \ # gzip - > $OUTPUTDIR/$1_$TODAY.sql.gz -----
backup.cnf must contain the host, username and password it should only the readable to your user (or the user running cron). --- [client] host = 127.0.0.1 user = drupal password = drupal ---
Then add something like this to the crontab: 0 1 * * * /path/to/dbbackup.sh databasename
Anisa.
[ Drupal support list | http://lists.drupal.org/ ]