ubuntu,debian,redhat -linuxany.com

How to backup MySQL databases, web server files to a FTP server automatically with Shell Script

Part I :System + Web + MySQL backup script  

This is a simple backup solution for people who run their own web server and MySQL server on a dedicated box or VPS. Most dedicated hosting provider provides the backup service using NAS or FTP servers. These service providers will hook you to their redundant centralized storage array over private VLAN. Since I manage couple of boxes, here is my own automated solution.

Making incremental backups with tar

You can make tape backups. However, sometime tape is not an option. GNU tar allows you to make incremental backups with -g option. For example following command will make incremental backup of /Data/apps,/Data/webapps, /home, and /etc directories:

Where,

• -g: Create/list/extract new GNU-format incremental backup and store information to /var/log/tar-incremental.log file.

Making MySQL databases backup

mysqldump is a client program for dumping or backing up mysql databases, tables and data. For example following command displays the list of databases:

Output:

Enter password:

cwiki tags ajax mysql phpads snews live csns myspaces workspaces

Now you can backup each database with mysqldump command:

A simple backup system plan

The main advantage of using FTP or NAS backup is a protection from data loss. You can use various protocols to backup data:

1. FTP
2. SSH
3. RSYNC
4. Other Commercial solutions

However, I am going to write about FTP backup solution here. The idea is as follows:

• Make full backup every Sunday night i.e. backup everything every Sunday
• Next backup only those files that has been modified since the full backup (incremental backup)
  This is a seven-day backup cycle.

Our sample setup

   Local Server     ===>>>     Remote Server[ftp/nas server] IP:211.10.10.10   ===>>>     221.10.10.10

Let us assume that your ftp details are as follows:

• FTP server IP: 221.10.10.10
• FTP Username: username
• FTP Password: passwd
• FTP Directory: /211.10.10.10/bak (or /)

You will store data at remote server as follows:
=>> /211.10.10.10/bak/full/mm-dd-yy/files – Full backup
=>> /211.10.10.10/bak/incremental/mm-dd-yy/files – Incremental backup

Automating tasks of backup with tar

Now you know how to backup files and mysql databases using tar and mysqldump commands respectively. It is time to write a shell script that will automate entire procedure.

1. First script will collect all data from both MySQL database server and from file system to temporary directory called /backup using tar command
2. Next, script will login to ftp server and create a directory structure at remote server as discussed above
3. Script will dump all files from /backup to ftp server
4. Script will remove temporary backup from /backup
5. Script will send you an email notification if ftp backups failed due to any reason.

You must have following command installed:

• ncftp ftp client

Note:  Build and Install ncftp client

         1.wget ftp://ftp.ncftp.com/ncftp/ncftp-3.2.0-src.tar.gz

         2.$ tar zxvf ncftp-3.2.0-src.tar.gz

        3.$cd ncftp-3.2.0

        4.$make&&make install

• mysqldump command
• GNU tar command

Here is the sample script:

Setup a cron job

Just add a cron job as per your requirements:

Part II :System+Web files backup script

It is time to write a shell script that will automate entire procedure.

1. First script will collect all data from both web and from file system to temporary directory called /backup using tar command
2. Next, script will login to ftp server and create a directory structure at remote server as discussed above
3. Script will dump all files from /backup to ftp server
4. Script will remove temporary backup from /backup
5. Script will send you an email notification if ftp backups failed due to any reason.

Here is the sample script:

#!/bin/sh
# System + MySQL backup script
# Full backup day – Sun (rest of the day do incremental backup)
# Copyright (c) 2005-2006 nixCraft
# This script is licensed under GNU GPL version 2.0 or above
# Automatically generated by http://bash.cyberciti.biz/backup/wizard-ftp-script.php
# ———————————————————————
### System Setup ###
DIRS=”/Data/apps /Data/webapps /home /etc”
BACKUP=/tmp/backup.$$
NOW=$(date +”%d-%m-%Y”)
INCFILE=”/root/tar-inc-backup.dat”
DAY=$(date +”%a”)
FULLBACKUP=”Sun”

###Create Archives###

您还可能感兴趣的内容

• MySQL Amoeba实现DB主从读写分离
• Eclipse + CDT + MinGW + MySQL环境搭建解决方案
• Improving Page Load Times(提升页面加载时间)
• MySQL InnoDB Performance Tuning(InnoDB性能调优)
• 用mysqldumpslow分析MySQL的slow query log