Just a small script I wrote to backup mysql via ZFS snapshots

zfs-backup-mysql.sh

#Just a small script I wrote to backup mysql via ZFS snapshots 
#!/bin/sh

# Copyright (c) 2011 Vladislav V. Prodan  <universite at ukr.net>

# My MySQL server uses the directory:
# tank/mysql # main directory MySQL
# tank/mysql/ibdata # data of InnoDB tables
# tank/mysql/iblogs # InnoDB transaction logs

/usr/local/bin/mysql -e 'FLUSH LOGS; FLUSH TABLES WITH READ LOCK; \
SYSTEM zfs destroy -r tank/mysql@yesterday; \
SYSTEM zfs rename -r tank/mysql@today @yesterday; \
SYSTEM zfs snapshot -r tank/mysql@today; \
SYSTEM zfs destroy -r tank/mysql/ibdata@yesterday; \
SYSTEM zfs rename -r tank/mysql/ibdata@today @yesterday; \
SYSTEM zfs snapshot -r tank/mysql/ibdata@today; \
SYSTEM zfs destroy -r tank/mysql/iblogs@yesterday; \
SYSTEM zfs rename -r tank/mysql/iblogs@today @yesterday; \
SYSTEM zfs snapshot -r tank/mysql/iblogs@today; \
UNLOCK TABLES;'