backup script

[sarma]

i would like to write a shell script to store database on daily basis. I am using MySQL 5 as my database. Any inputs are welcome...


regards
sarma

[ronverdonk]

Are you talking about an SQL statement backup or a binary dump?

Ronald :cool:

[sarma]

I would like to write some shell program which will be automatically run by crond and take data which is effected on that day. It will store only updates or modifications.


regards
sarma

[sashi]

I would like to write some shell program which will be automatically run by crond and take data which is effected on that day. It will store only updates or modifications.


regards
sarma

Hi there,

If that's the case, i would suggest you to use mysqldump, add a line to crantab to make a backup, hope it helps.

Kindly refer to below attached link for futher reading & understanding. Good luck & Take care.

http://www.adminschoice.com/docs/crontab.htm

http://www.ss64.com/bash/crontab.html

[sarma]

Hi one and all,


ThanQ very much for your response....... ............... ............




thanx
sarma