I finished configuring my first production server, and I'm thinking about strategy to backup data.
In my head this task has 3 faces.
- Filesystem (ubuntu itself)
Strategy 1. Every 6 month tarball Filesystem and save it to remote server in other location. 2. Every sunday create sql dump and save to remote server 3. No need to backup, webroot is on SVN remote server.
What do you think about this?
Now my question is, how do I scp tar/dump files to remote server in secure way? I will have to create little shell script that would make backup files automatically and move them to remote, but that will require putting ssh access directly in plain file.