[rt-users] Backing up RT

[Konstantin Khomoutov]

On Wed, 5 Jan 2011 14:52:51 +0100
Emmanuel Lacour <elacour at easter-eggs.com> wrote:

>> You use logrotate to manage your mysqldumps!  Excellent idea.
> 
> if you are using Debian, the command "savelog" is also often
> convenient to rotate a file at the beginning or end of a script.
> 
> saveloq -q /var/backups/mysql/dump.sql.gz
> mysqldump ... | gzip -c > /var/backups/mysql/dump.sql.gz

Speaking about Debian, I would also add that there's no need to create
a special user to do backups as Debian already provides one with
sufficient privileges for maintenance purposes, so one can just pass
the relevant config file to various MySQL utilities, like this:

# mysqldump --defaults-file=/etc/mysql/debian.cnf --opt ... 

I'm quite sure other distros do something akin to this, so it could
probably be adapted.