I need to run cronjobs to backup some of my databases daily and scp them over to another box.
I'm debating with my brain if I should just use one filename and have it overwrite the file every day or use multiple names (like a date) and manually delete them when I get a chance.
How would I do this? I know how to back up the databases using the shell, but I don't know how to instruct the command what the database password is or what the user/pass of the other box is.
Can anyone help me out?
I'm debating with my brain if I should just use one filename and have it overwrite the file every day or use multiple names (like a date) and manually delete them when I get a chance.
How would I do this? I know how to back up the databases using the shell, but I don't know how to instruct the command what the database password is or what the user/pass of the other box is.
Can anyone help me out?