Shell script for backup and restore

[inddeveloper]

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(.sh files) for the above backup and restore functionalities.

Thanks in advance

[Kloschüssel]

Take a look at:

http://www.linuxforums.org/forum/lin...up-script.html

[barbus]

The simplest way to backup MySQL database is to use myqldump:

mysqldump --opt --quick -u $DBUSER -p$DBPASS $db > $BACKUP_DIR/mysql-$db-$DATEPREFIX.sql

and then gzip it or compress it via pipe.


I posted the example of incremental backup script to thread pointed above.

To upload backup to FTP server you can use:

ncftpput -u $FTP_USER -p $FTP_PASSWORD $FTP_SERVER  / $BACKUP_FILE