incremental backup in linux

Chuck56 · 09-29-2010, 10:18 AM

Quote:

Originally Posted by dinakumar12

I have another question,if i need to remove the seven days old database dump,what should be added to the script.

That depends on what script are you using. Did you decide to run rsnapshot or are you using something else?

dinakumar12 · 09-29-2010, 12:54 PM

Hi,

I used the same script which you have provided only made slight changes to dump my mysql database,as i have poor knowledge in shell scripting.

no i didn't use rsnapshot.i have just edited a file with the script you have given and gave executable permission for that file,and allotted a cron job to run that file once in a day.

Chuck56 · 09-29-2010, 01:03 PM

As I mentioned in my earlier reply, I use the mysql dump script with rsnapshot.

If you choose to use rsnapshot, which is really a package of rsync shell scripts, then backup rotations are handled by automatically. I can help you include the mysql script in rsnapshot.

If you are writing your own scripts then you'll need to post the scripts so we can all help.

dinakumar12 · 10-07-2010, 02:13 AM

Hi chuck,

Sorry for the delayed reply. I have added this line to the script to delete the seven days old backup.

" find /var/tmp -mtime +6 -daystart -exec rm -rf {} \; "

and it seems to work.

But i followed this link to take incremental backup of my server

http://blog.umeshupreti.com/technica...ckup-with-tar/

but every time when i take incremental backup it backsup all folders, it only omits the files which are not changed but it backs up all the folders.

so is there any way to take incremental back up of both files and folders which have been recently changed before the recent backup.

goldenbarb · 10-07-2010, 04:07 AM

It would be better to use find ... -delete instead of find ... -exec rm -rf {} \;

dinakumar12 · 10-11-2010, 01:52 AM

Hi all,

is it possible to restore a database using script,it can be mysql or postgresql. if possible how to achieve that.you suggestions would be very helpful.

Thanks in advance,
Dinesh.

dinakumar12 · 10-13-2010, 01:03 AM

Hi chuck,

I want the scripts to write to a log file every time it runs. so that i can check the log file whether the the script is properly run to generate the backup.

so what should be added to the script.

Thanks in advance,
Dinesh.

Chuck56 · 10-13-2010, 01:13 AM

I use rsnapshot, not tar, to backup. http://www.rsnapshot.org/

rsnapshot uses rsync and hard links to save space. It updates logs files after completion and can send out email as well.