2

I'm trying to backup my /var/www/ folder, MySQL, and any other special documents like in the /etc/apache2/ folder.

Does anyone have any solutions for backup software? Maybe something that's Cronjob-able?

5

The best backup solution is highly dependent on your requirements. It's best to start with a backup strategy and let your strategy inform your choice of software. At minimum, you'll want to read enough to know the difference between the common backup types (incremental, differential, full).

If incremental backups aren't important, rysnc + mysqldump should work fine for your scenario. If you really need/want incrementals, Amanda or Bacula are good choices. My company has used Amanda for its backup needs for several years, and we've been very satisfied. Zmanda also provides a tool for backing up MySQL databases.

Whatever solution you do chose, though, test your backups! Don't just check to see if the backup succeeded, do a restoration (preferably from "bare metal") to verify the files are restored correctly. There's nothing worse than discovering your backup is incomplete when you've just clobbered critical files.

Also, if you're backing up a production environment, make sure at least one of your backups is an encrypted off-site backup.

Good luck!

2

In my opinion backuppc is the best backup solution for multiple server.

Backuppc uses a dedicated server to backup different hosts. Every hosts can be configured separately (what to backup, backup schedule, transfer method (including rsync), ...)

pre and post backup jobs can automatically be launched (e.g. dump mysql tables)

administration is done by web interface

installation is done by apt-get install backuppc

Install via the software center

1

Try rsync, I think it will provide all the functionality you're looking for. In order to handle MySQL you might need to write an additional cronjob to dump the database as well.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.