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/ ]