Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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


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.