hosting backup script

Question

Backup

I have a small Ubuntu server at my house. I thought about hosting backups, where the sites are located.

Tell me, are there ready-made solutions for hosting backups? It is necessary that there are backups of both the files themselves (downloaded from FTP and via sftp) and mysql databases.

And it would be nice if the backup was intellectual. That is, thousands of files were not downloaded each time (for a long time), but only changed ones.

Well, if there is an opportunity to make different backups (for example, daily, weekly and monthly prescriptions), then it would be generally gorgeous.

Answer 1

I can recommend backing up to the Selectel cloud storage :-)
For convenient file upload, the supload utility has been prepared , which allows you to upload only changed files and check the integrity of the data. You can also use this utility in other scripts to implement more complex backup logic.
To prepare a dam of mysql databases, it is convenient to use the automysqlbackup utility , it has many useful functions and settings.
Another useful utility for creating backups at various intervals is rsnapshot .

Answer 2

Not the easiest, but worthy way:
- Install a version control system on your home server. For example Subversion. As a storage (although you need an external IP)
- we add the site to the storage and a working copy to the hosting
- on the hosting in cron we write a small script that dumps the database to a file and makes svn ci at the root of the site.
Troublesome and on the wrong side, but completely fulfills the tasks. Plus versioning.
habrahabr.ru/post/26117/

Answer 3

recently asked

Answer 4

We use automysqlbackup for databases, duplicity for files. We store everything in Selectel.

Answer 5

I recommend rubygem Backup .
Wonderful DSL and all the necessary features:

• databases : postgres, mysql, mongodb, redis, riak
• syncers : rsync, amazon s3, rackspace
• storages : ftp, scp, dropbox, s3
• notifiers : email, twitter, campfire

Answer 6

a couple of years ago, we used a bash script as a temporary solution to make backups and a python script to take them to another machine:

Answer 7

We use backup-ninja, it can do everything it needs, it copes fine.