Here's what I do:
cd /home/www tar --totals -cpf /home/www/backups/www.domain.org.tar www.domain.org mysqldump -u root -h localhost -p"password" drupal > /home/www/backups/drupal_dump.sql ftp -n </home/www/backups/ftpcommands mail -s "Backup Success" email@domain.com < /home/www/backups/mailtext
The tar backs up the directories into a tar file The mysqldump creates a mysql dump of the drupal database to a .sql file
I then FTP these files to my backup server and email myself a message
I saved this as backup.cron and placed it in my /etc/cron.daily directory.
--- Anisa mystavash@animecards.org wrote:
So, the other day, my server's database completely crashes. They restored it, but you know.. scary stuff. And of course, while I could imagine files mysteriously disappearing, and kept backups of all that, I never thought about the database, so I was backupless.
But it's a pain to manually do regular backups, any ideas on how to automate it? I use mysql, and normally access it with phpmyadmin. That is, if there are any good ideas that don't involve cron jobs. ^.^:
Anisa.
[ Drupal support list | http://lists.drupal.org/ ]
__________________________________ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail