Easiest way is to use crontab and mysqldump to run a script like this:
#!/bin/bash
#Use mysqldump to dump the entire Rivendell database and then gzip it
with todays date
mysqldump -u rduser -pletmein --compress Rivendell | gzip -c9 >
/home/administrator/backups/rivendells2.`date +"%Y-%m-%d"`.gz
#Copy this to the backup server
#Copy via scp and limit it to 16000bits/sec ~= 2MB/sec
#scp line is wrapped, put on one line
scp -l 16000 /home/administrator/backups/rivendells2.`date
+"%Y-%m-%d"`.gz [email protected]:/data/backups/rivendell/
You have to setup ssh keys if you want to do the backup to another
server. Or you could mount a share somewhere.
Wayne Merricks
The Voice Asia
On 26/08/15 12:53, Stan Fotinos wrote:
Was referring to Rivendell's backup setup in RDadmin
Thanks
Stan
On 26/08/2015 7:34 pm, Cowboy wrote:
On 08/26/2015 07:26 AM, Stan Fotinos wrote:
Hi all
Is there a way to set the time for the daily automatic backup for
the database?
I have noticed that this takes place when you last did a manual back
up at the same time every 24 hours.
Depends on the tool you're using to do the backup.
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
