Duplicity 0.7.08 recently released, allows you to backup directories by producing encrypted tar-format volumes and uploading them to a remote or local file server. Because duplicity uses librsync, the incremental archives are space efficient and only record the parts of files that have changed since the last backup. The duplicity package also includes the rdiffdir utility. Rdiffdir is an extension of librsync’s rdiff to directories—it can be used to produce signatures and deltas of directories as well as regular files.
zbackup is a globally-deduplicating backup tool, based on the ideas found in rsync. Feed a large .tar into it, and it will store duplicate regions of it only once, then compress and optionally encrypt the result. Feed another .tar file, and it will also re-use any data found in any previous backups. This way only new changes are stored, and as long as the files are not very different, the amount of storage required is very low.
Percona has just announced the release of Percona XtraBackup 2.2.8. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona XtraBackup drives down backup costs while providing unique features for MySQL backups. New Features: Percona XtraBackup has been rebased on MySQL 5.6.22. Bugs Fixed: Incremental backups would fail if the number of undo tablespaces (innodb_undo_tablespaces) was more than 1.
I had a situation where I needed to backup hundreds of databases to a USB drive. In this circumstance the GUI was out of the question. After some searching online I found this script: [sourcecode language="sql"]<br />DECLARE @name VARCHAR(50) -- database name<br />DECLARE @path VARCHAR(256) -- path for backup files<br />DECLARE @fileName VARCHAR(256) -- filename for backup<br />DECLARE @fileDate VARCHAR(20) -- used for file name<br /><br />SET @path = 'D:\SQL\Backup\'<br /><br />SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)<br /><br />DECLARE db_cursor CURSOR FOR<br />SELECT name<br />FROM master.