#!/bin/bash
# Nightly backup system for home directories and MySQL
# databases for websites managed by CPanel.
# Author: Kieran O'Shea
# Author's Website: www.kieranoshea.com
# Support: kieran@kieranoshea.com
# License: GPLv2
# USAGE: Place this file inside the directory you want to
# put backups in, set it as a CRON job to run and collect
# backups from the site(s) you define below at a preset
# time each day, or run it manually everytime you want to
# take a backup. You can place an unlimited number of sites
# and databases to be backed up in the variables below so
# long as you follow the convention. It doesn't even matter
# if your different domains are hosted in different locations
# so long as they are all managed by CPanel.
# Prerequisites:
# - Linux box with bash shell
# - wget installed
# Define all the sites you wish to backup in the array below
# Domain name and tld only, eg. kieranoshea.com
domain=( domain1.com domain2.com )
# Define all the usernames for the above sites in the array
# below - keep order consistant!
user=( user1 user2 )
# Define all the passwords for the above usernames in the
# array below - keep order consistant! If you log on as
# reseller or root you can enter the same password in
# every array position, but none the less they must be filled.
pass=( pass1 pass2 )
# Number of databases in each domain above - keep order
# consistant. If you don't wish to backup any databases
# for a particular domain, or don't have any for it, place
# a 0 in it's position in the array.
no_of_db=( 3 1 )
# Database names, exactly as they are in CPanel, in the order
# that the domains appear. You may like to log into CPanel
# manually and check your database names before filling this
# variable in. Number of db names here must match the above
# variables also! Eg. all dbs in domain 1 followed by all
# dbs in domain 2 etc. You DO NOT need to enter any database
# names below for a domain if you have placed a zero for it
# in the array above
databases=( domain1_datebase1 domain1_datebase2 domain1_datebase3 domain2_datebase1 )
# Thats all folks, save the file, CHMOD it to be executable
# by the user who will run it, and you are all set.
# Do not edit anything below this point!
echo
echo "-----------------------------------------------------------------"
echo "Kieran's nightly backup system started"
echo "-----------------------------------------------------------------"
echo ""
echo "-----------------------------------------------------------------"
echo "Creating a directory in your backup path for tonights backup..."
echo "-----------------------------------------------------------------"
FOLDER="$(date +%d-%m-%Y)"
mkdir $FOLDER
cd $FOLDER
echo "-------"
echo "Done!"
echo "-------"
echo ""
echo "-----------------------------------------------------------------"
echo "Creating a directory for every domain to be backed up into..."
echo "-----------------------------------------------------------------"
count=${#domain }
i=0
while [ "$i" -lt "$count" ]
do
mkdir ${domain[$i]}
let "i = $i + 1"
done
echo "-------"
echo "Done!"
echo "-------"
echo ""
echo "-----------------------------------------------------------------"
echo "Backing up MySQL databases..."
echo "-----------------------------------------------------------------"
overall_db_count=0
count=${#domain }
i=0
while [ "$i" -lt "$count" ]
do
cd ${domain[$i]}
mkdir databases
cd databases
start_point=$overall_db_count # start point for iterating over the array of db names
let "end_point = $overall_db_count + ${no_of_db[$i]}" # end point to stop iterating (always the overall count!)
n=$start_point
while [ "$n" -lt "$end_point" ]
do
wget http://${user[$i]}:${pass[$i]}@www.${domain[$i]}:2082/getsqlbackup/${databases[$n]}.gz
let "n = $n + 1"
done
let "overall_db_count = $overall_db_count + ${no_of_db[$i]}" # increase the overall count to keep a tally
cd ..
cd ..
let "i = $i + 1"
done
echo "-------"
echo "Done!"
echo "-------"
echo ""
echo "-----------------------------------------------------------------"
echo "Backing up home directories; this make take some time..."
echo "-----------------------------------------------------------------"
count=${#domain }
i=0
while [ "$i" -lt "$count" ]
do
cd ${domain[$i]}
wget http://${user[$i]}:${pass[$i]}@www.${domain[$i]}:2082/getbackup/backup-${domain[$i]}-$FOLDER.tar.gz
cd ..
let "i = $i + 1"
done
echo "-------"
echo "Done!"
echo "-------"
echo ""
echo "-----------------------------------------------------------------"
echo "All backup tasks completed. Goodnight!"
echo "-----------------------------------------------------------------"
Alfre Gates on 01 Dec 10"Copia de seguridad completa, archivos y bases de datos MySQL Para comenzar voy a comprimir el directorio donde se encuentran todos mis Blogs, así que nos situamos en nuestro servidor remoto y localizamos el directorio que queramos hacer la copia de seguridad, en mi caso es /home/usuario/www/ del cuelgan todos los directorios donde tengo los Blogs … cd /home/usuario Ahora comprimiremos el directorio ( www ) con … tar -czf /home/usuario/backupwww.tar.gz /home/usuario/www Una vez comprimido aremos una copia de seguridad masiva de todas las bases de datos que tenemos con … mysqldump -uroot -pPASSWORD --all-databases > /home/usuario/backupmysql.`date +%Y%m%d`.sql (Esta ultima linea es toda seguida no partida en dos ) Donde pone password introducid el password que tenga root en la base de datos MySQL no en el sistema. Una vez hechas las dos copias de seguridad ya tenemos todo lo que necesitamos para restaurarlo todo en caso de catástrofe. backupwww.tar.gz y backupmysql.sql los tenemos en el directorio /home/usuario y en caso de necesitarlos los tenemos hay pero si recordamos al principio del articulo eliminamos las pegas de la petición del password al acceder a nuestro servidor en casa. Si nuestro servidor casero no necesita que le introduzcamos el password a mano podremos enviar estos dos ficheros por una conexión segura vía sftp. El tema está en automatizar el proceso para que no tenga que hacerlo yo a mano y ya que tengo estas dos maquinas conectadas las 24 h porque no vamos a dejarlas que cumplan ellas dos solas esta tarea por nosotros. Una vez hechas las copias de seguridad de todo lo que necesitamos tanto de los directorios como de las bases de datos MySQL necesitamos enviarlos a nuestro servidor casero con sftp. Para hacer esto vamos a usar el programador de tareas por defecto en todos los sistemas operativos GNU/Linux. Con Cron podremos decirle a que hora hacer las copias de seguridad y a que hora enviarlas a nuestro servidor casero que
