Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

Hey I am using mysql in ubuntu along with 15 more ppl who also has root privilege.
I am afraid they might accidentally tamper with the database, so I want to take a daily and hourly incremental backup of the database, and its privileges.

Can anyone help me with a solution?

Note: I can cron mysqldump, but I need to do svn kind of thing so that I can see the changes, too.

share|improve this question

1 Answer 1

up vote 4 down vote accepted

The repository contains an application for taking backups: automysqlbackup. Backups are made from the whole database, including privileges, and placed in /var/lib/automysqlbackup/. This can be changed in /etc/default/automysqlbackup.

About the versioning part, the repository only grows in size. A better solution might be diffing two backups. Such a script can be setup using the POSTBACKUP hook (see the bottom of /etc/default/automysqlbackup).

You might also be interested in a similar question on Serverfault: Incremental MySQL Backup using Subversion

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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