Do you backup your Website MySQL Database?

I backup my site every night.

I added a simple script in my cron.daily ...

This is a part of the script who do the backup

#!/bin/bash

M="mysql --defaults-file=/home/backup/debian.cnf"
MA="mysqladmin --defaults-file=/home/backup/debian.cnf"
MD="mysqldump --defaults-file=/home/backup/debian.cnf"

DATE=`date +%m-%d-%y`

LOG=/home/backup/night-$DATE.log
my_exit () {
   exit $1
}


# Test if the server is up and running.
if ! $MA --silent ping >/dev/null; then
  my_exit 0
fi


$MD -t database > /home/backup/dump-$DATE.sql
gzip -9 /home/backup/dump-$DATE.sql >> $LOG

Code (markup):

Regards
Adrian

 

I make backups about once a month. This summer I plan to make a weekly backup though

 

Thanks for the link. I'm going to check into that.