Simple linux FTP backup script

Written by on Sunday, June 1, 2008 23:30 - 0 Comments

This is a quick and simple linux FTP backup script we use to run on clients servers that have small backups that need to be shipped off to a remote FTP server somewhere.  You can basically backup anything from here, Mysql, Apache config files, webserver files etc…

Shell access
Vi or Pico/Nano editor

Step 1:
Log into your server as the user you want to run this script as (usually root).  You can then create a file somewhere on your server (I usually put the file in /etc/backup)

# cd /etc
# mkdir backup
# cd backup
# nano

Step 2:
Cut and paste the script I have written into the file and then edit the parts required (it is spretty streight forward to understand but I will put comments on each line — the comments will start with a * so do not add these comments into your script).  After you have edited and save the file you must chmod the file 755 to make it executable

* this can be an ip address or a hostname of the destination FTP server
* the username of the ftp server
* the password on the ftp server
DATE=`/bin/date +%Y%m%d`
* no edits for DATE
TIME=`/bin/date +%H`
* No Edits for TIME
* No edits for HOSTNAME

mysqldump -c -B -uroot -pfoobar DB1 DB2 mysql > data.sql &&
* This is if you want to backup your mysql database, DB1 and DB2 represent databases within mysql you want yo backup -uroot -pfoobar (change this to your mysql username and password). if you are not backing up mysql then remove the above line.

tar zcvf $DATE.$TIME.$HOSTNAME.tar.gz ./data.sql /etc/ /var/www > /dev/null &&
* you can edit this line as you wish if you are not backing up mysql you can remove ./data.sql, you can add directories such as /etc and /var/www

ncftpput -u $USER -p $PASSWD $HOST /tobebackedup $DATE.$TIME.$HOSTNAME.tar.gz ;:
* nothing to edit here

The finished script:

DATE=`/bin/date +%Y%m%d`
TIME=`/bin/date +%H`

mysqldump -c -B -uroot -pfoobar DB1 DB2 mysql > data.sql &&
tar zcvf $DATE.$TIME.$HOSTNAME.tar.gz ./data.sql > /dev/null &&

ncftpput -u ftpbackup -p backup0012 $HOST /tobebackedup $DATE.$TIME.$HOSTNAME.tar.gz ;:

Running the script on a schedule (Crontab howto):
as the user that you want to run the backup script as type the following commands:

crontab -e
To run weekly on Sunday enter the line:
* * * * 6 /etc/backup/

Article written by

Comments are closed.

Ad Sponsor


2003 server - Sep 30, 2008 22:34 - 0 Comments

instant messaging srv records

More In Computers & PC

Microsoft Outlook - Mar 22, 2009 11:22 - 0 Comments

Outlook: Duplicates in Mailbox

More In Computers & PC

Microsoft Desktop, Web browsers and Internet, Windows 2000, Windows 7, Windows 98, Windows Firewall and networking, Windows Vista, Windows XP - Feb 8, 2010 18:09 - 0 Comments

Disable Proxy settings in IE

More In Computers & PC