Bashscripts.org

Hi,

I have requirement on shell scripting. I require scripts for the following
1) Full backup(application and DB): tar all the files and database and copy them in the backup server
2) incremental back up of files: backup of all the updated files after the last backup
3) restoring of backup files: restore the backup files from the backup server to the application server

Please help me in providing the scripts.

Thanks in advance

Hi,

Your request does not provide anywhere near the specification required to write the script so it's impossible to do reasonably, eg;

1) rsync -a /mydata backupserver:datastore
2) rsync --delete -a /mydata backupserver:datastore
3) rsync --delete -a backupserver:datastore /mydata

I suggest you actually use backup software;
http://www.google.co.uk/#q=linux+backup+software

Thanks for the reply

Buy i need to backup(both application files and MYSQL DB) and restore using shell scripting.

For Backup i need to tar all the files and DB and moved to the backup server/

For Restore i need to copy the backup files from the backup server to local sever.

For incremental backup i need to backup the files which are updated after the last backup

Please help me in providing the linux shell scripts for the above tasks

Thanks

Hi, sorry for the not really what you want to hear reply

Backing up mysql and app files to a tar file is reasonably easy, as is restoring them. However incremental backups into tar will be tricky. The script will likely either be complex or too basic and fiddly. If this is a school project or similar basic and fiddly would likely be ok heh.

Much *nux backup software will have command line access to it's functions and will be able to cope with mysql data and the propriety ones will likely also have incremental backups. I doubt very much that you're going to get incremental backups to tar using a script written here for free, I certainly do not have the time, sorry.
If someone else does that's great, indeed they could then publish it to a website under GPL and everyone could use it...oh yeah several people already have and they're searchable for on google

The following are some basic pointers, if you wish to have a go at writing it yourself I'll attempt to help with problems you encounter.

You can use mysqldump to backup mysql data;
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

You can restore mysql data using the dumped backup and piping it into mysql client similar to this;
mysql < backup.sql

To tar files up;
cd /path/to/app/
tar czf backup.tgz files/

To restore the tar files;
cd /path/to/app/
tar xzf backup.tgz

To copy to another server;
scp backup.tgz my.backup.server:/backup/location/

I have created a script file to dump the application files using the following script

Code
=============
#!/bin/bash
#Full Day Backup Script
#application folders backup

now=$(date +"%d-%m-%Y")
#use 1 instead of 0 which is incremental backup
dump -0f $now /var/www/html/*
=============

using this we can successfully dumped the application files.

Now i want to restore the dumpfile

How can i restore using shell script?

please help

Thanx in advance