mysqlmybackup.sh – multi feature MySQL database backup and restore script with Percona XtraBackup & Mydumper tool support
Examples:
Basic email notification message:
Backing up database: [sbtest] if mysql user password is empty hit enter at prompt 134MB 0:00:08 [16.5MB/s] [ <=> ] Successfully backed up database: sbtest |
Percona XtraBackup email notification:
Subject: MySQL Backup Notification for localhost.localdomain: Sun Jun 26 16:17:13 EST 2011 Deleting older backup: /mysqlbackup/xtrabackup/2011-07-30_17-27-43: OK Successfully backed up all databases using Percona XtraBackup / innobackupex mysqlmybackup.sh v0.9.6 http://vbtechsupport.com/974/ ******************************************************* Getting MySQL datadir location if mysql user password is empty hit enter at prompt --------------------------------------------- /mysqlbackup resides on partition which has 2222 Megabytes of disk space available --------------------------------------------- MySQL data directory located at: /var/lib/mysql/ MySQL data directory size in Megabytes: 1161 --------------------------------------------- [PASS] you have enough free disk space to store MySQL data directory size on /mysqlbackup ******************************************************* Full MySQL data directory backed up at: /mysqlbackup/xtrabackup ******************************************************* Jul 30 17:39 4.0K 2011-07-30_17-38-39 XtraBackup last backup directory created at: 2011-07-30_17-38-39 Jul 30 17:38 382 backup-my.cnf Jul 30 17:38 50M ibdata1 Jul 30 17:38 0 mysql-stderr Jul 30 17:38 1 xtrabackup_binlog_info Jul 30 17:38 4.0K db2 Jul 30 17:39 4.0K sbtest Jul 30 17:39 4.0K roundcube Jul 30 17:39 4.0K horde Jul 30 17:39 2.5K xtrabackup_logfile Jul 30 17:39 83 xtrabackup_checkpoints Jul 30 17:39 4.0K test Jul 30 17:39 312 mysql-stdout Jul 30 17:39 4.0K mysql Jul 30 17:39 10 xtrabackup_binary |
Mydumper email notification:
Subject: MySQL Backup Notification for localhost.localdomain: Sun Jun 26 15:55:44 EST 2011 Deleting older backup: /mysqlbackup/mydumper/export-20110730-164247: OK Successfully backed up all databases using mydumper mysqlmybackup.sh v0.9.6 http://vbtechsupport.com/974/ ******************************************************* Getting MySQL datadir location if mysql user password is empty hit enter at prompt --------------------------------------------- /mysqlbackup resides on partition which has 2217 Megabytes of disk space available --------------------------------------------- MySQL data directory located at: /var/lib/mysql/ MySQL data directory size in Megabytes: 2141 --------------------------------------------- [PASS] you have enough free disk space to store MySQL data directory size on /mysqlbackup ******************************************************* mydumper created MySQL database backups at: /mysqlbackup/mydumper ******************************************************* Jul 30 17:13 12K export-20110730-171324 mydumper last backup directory created at: export-20110730-171324 Jul 30 17:13 258 sbtest.sbtest2-schema.sql.gz Jul 30 17:13 257 sbtest.sbtest1-schema.sql.gz Jul 30 17:13 322 mysql.user.sql.gz Jul 30 17:13 611 mysql.user-schema.sql.gz Jul 30 17:13 78 mysql.time_zone_transition_type.sql.gz Jul 30 17:13 281 mysql.time_zone_transition_type-schema.sql.gz Jul 30 17:13 78 mysql.time_zone_transition.sql.gz Jul 30 17:13 239 mysql.time_zone_transition-schema.sql.gz Jul 30 17:13 78 mysql.time_zone.sql.gz Jul 30 17:13 245 mysql.time_zone-schema.sql.gz Jul 30 17:13 78 mysql.time_zone_name.sql.gz Jul 30 17:13 222 mysql.time_zone_name-schema.sql.gz Jul 30 17:13 78 mysql.time_zone_leap_second.sql.gz Jul 30 17:13 244 mysql.time_zone_leap_second-schema.sql.gz Jul 30 17:13 78 mysql.tables_priv.sql.gz Jul 30 17:13 417 mysql.tables_priv-schema.sql.gz Jul 30 17:13 78 mysql.slow_log.sql.gz Jul 30 17:13 320 mysql.slow_log-schema.sql.gz Jul 30 17:13 78 mysql.servers.sql.gz Jul 30 17:13 271 mysql.servers-schema.sql.gz Jul 30 17:13 78 mysql.proc.sql.gz Jul 30 17:13 78 mysql.procs_priv.sql.gz Jul 30 17:13 393 mysql.procs_priv-schema.sql.gz Jul 30 17:13 845 mysql.proc-schema.sql.gz Jul 30 17:13 78 mysql.plugin.sql.gz Jul 30 17:13 224 mysql.plugin-schema.sql.gz Jul 30 17:13 78 mysql.ndb_binlog_index.sql.gz Jul 30 17:13 251 mysql.ndb_binlog_index-schema.sql.gz Jul 30 17:13 78 mysql.host.sql.gz Jul 30 17:13 393 mysql.host-schema.sql.gz Jul 30 17:13 117K mysql.help_topic.sql.gz Jul 30 17:13 283 mysql.help_topic-schema.sql.gz Jul 30 17:13 3.2K mysql.help_relation.sql.gz Jul 30 17:13 228 mysql.help_relation-schema.sql.gz Jul 30 17:13 3.2K mysql.help_keyword.sql.gz Jul 30 17:13 235 mysql.help_keyword-schema.sql.gz Jul 30 17:13 572 mysql.help_category.sql.gz Jul 30 17:13 263 mysql.help_category-schema.sql.gz Jul 30 17:13 78 mysql.general_log.sql.gz Jul 30 17:13 294 mysql.general_log-schema.sql.gz Jul 30 17:13 78 mysql.func.sql.gz Jul 30 17:13 282 mysql.func-schema.sql.gz Jul 30 17:13 262 mysql.event.sql.gz Jul 30 17:13 924 mysql.event-schema.sql.gz Jul 30 17:13 169 mysql.db.sql.gz Jul 30 17:13 403 mysql.db-schema.sql.gz Jul 30 17:13 78 mysql.columns_priv.sql.gz Jul 30 17:13 348 mysql.columns_priv-schema.sql.gz Jul 30 17:15 461M sbtest.sbtest2.sql.gz Jul 30 17:15 461M sbtest.sbtest1.sql.gz Jul 30 17:15 75 metadata |