Q:

Overwrite a Backup

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,

A:

Have a look at mysqldump.
mysqldump db_name tbl_name > backupfile.sql

will dump the a db / table and overwrite backupfile.sql if it exists.
Use rsync or scp to copy it to another host if needed.

