I need to set up a job to create backup everyday. I also need to overwrite an existing backup. Can somebody please help me with it.
Thanks,
I need to set up a job to create backup everyday. I also need to overwrite an existing backup. Can somebody please help me with it.
Thanks,
Have a look at
mysqldump
.will dump the a db / table and overwrite backupfile.sql if it exists.
Use
rsync
orscp
to copy it to another host if needed.