Simple MySQL backup script built on percona xtrabackup

mysql-backup

#!/usr/bin/env ruby

# In order to use this script, you need a backup user:
# CREATE USER backup@localhost;
# GRANT SELECT, USAGE, PROCESS, RELOAD, CLIENT REPLICATION ON *.* TO backup@localhost;

require 'fileutils'

BACKUP_DIR = "/srv/mysql"
MYSQL = "/usr/bin/mysql"
XTRABACKUP = "/usr/bin/xtrabackup"

DATABASES = `mysql -u backup -e "SHOW DATABASES"`.split(/\s+/).grep_v(/Database|_schema|_test|_restore/)

FileUtils::Verbose.rm_rf Dir.glob File.join(BACKUP_DIR, '*')

system(XTRABACKUP, "--backup", "--user=backup", "--databases", DATABASES.join(' '), "--compress", "--compact", "--target-dir", BACKUP_DIR)