This site is hosted and sponsored by hyve.com specialists in Cloud Hosting UK and VMware Hosting. If you are interested in our services please call us for chat on 0800 612 2524

• Setup backup.sh file in /root folder

mkdir /var/lib/mysql_backup

vi /root/backup.sh

#!/bin/sh
# all db separate files

for customerdb in `mysql -uuser -e "show databases" -B -N`
do
        echo $customerdb
        mysqldump -uuser $customerdb > /var/lib/mysql_backup/$customerdb.sql
done

chmod 700 /root/backup.sh

• Setup Crontab so backup runs at mighnight every night

vi /etc/crontab

0 0 * * * root  /root/backup.sh