*nix Script needed for backup job

[ICTNUT]

Hi All,

 

I wonder if anybody has a script or scripts that will do the following:

 

1 - Full dump of mysql db to \usr\backups\mysql\mysqldump-dd-mm-yy.sql

2 - copy var\www\*.* to usr\backups\www

3 - copy var\moodledata to usr\backups\moodledata

4 - zip or tar the backups folder (usr\backups) and give a name of backup-dd-mm-yyyy.zip

5 - FTP to another NAS server internal (TeraStation)

6 - Once successfull rename rename the backups folder and create a new one.

 

This is the only way I can think of having this server fully covered in the event of a disaster.

 

Any ideas would be greatly apreciated ;-)

[CyberNerd]

#!/bin/sh
export PATH=/bin:/usr/bin:/sbin:/usr/sbin 
# List of databases to be backed up separated by space
dblist="drupal itreservations moodle mysql"    

# Directory for backups
backupdir=/path/to/directroy   #edit

# Number of versions to keep
numversions=4

# Full path for MySQL hotcopy command
hotcopycmd=/usr/bin/mysqlhotcopy

# MySQL Username and password
userpassword=" --user=root --password=password"

# Create directory if needed
/bin/mkdir -p ${backupdir}
if [ ! -d ${backupdir} ] 
then
       /bin/echo "Invalid directory: ${backupdir}"
exit 1
fi

# Hotcopy begins here
echo "Hotcopying MySQL Databases..."
RC=0
for database in $dblist
do
       /bin/echo "Hotcopying $database ..."
       $hotcopycmd $userpassword $database ${backupdir}
       RC=$?
       if [ $RC -gt 0 ]
       then
               break;
       fi

       # Rollover the backup directories
       i=$numversions
       /bin/mv ${backupdir}/${database} ${backupdir}/${database}.0 2> /dev/null
       /bin/rm -fr ${backupdir}/${database}.$i 2> /dev/null
       while [ $i -gt 0 ]
       do
               /bin/mv ${backupdir}/${database}.`expr $i - 1` ${backupdir}/${database}.$i 2> /dev/null
                i=`expr $i - 1`
       done
done

if [ $RC -gt 0 ]
then
       /bin/echo "MySQL Hotcopy failed!"
       exit $RC 
else
       # Hotcopy is complete. List the backup versions!
       /bin/ls -l ${backupdir}
       /bin/echo "MySQL Hotcopy is complete!"
fi
exit 0

 

the above script will do the mysql backup (hotcopy) edit paths, passwords and database names to your requirements. to copy things just add something along the lines

 /usr/bin/rsync -avrlHKpogDt /var/www/ /backup/path 

or cp -a to keep things simple

for date time thing something like

#!/bin/bash
time=`/bin/date +%Y-%m-%d`

backup_dir=/backup/$time
/bin/mkdir -p $backup_dir
/bin/tar zcvf $backup_dir/backup.tar.gz /backup/ 2&> /dev/null

# to remove any backup older that 14 days
/usr/bin/find /backup -type d -mtime +14 -exec /bin/rm -rf {} \;

 

hope theres something useful in there

personally I use rsync to back up the servers to remote boxes rather than ftp

[ICTNUT]

Thanks very much for the above.

 

I'll see what I can hash together from it.