mysqlmybackup.sh – multi feature MySQL database backup and restore script with Percona XtraBackup & Mydumper tool support

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

[root@localhost ~]# ./backup.sh backup
What is your mysql username password ? 
 
myslusername
 
What is your mysql user password ? 
 
***********
 
*******************************************************
Getting MySQL datadir location
if mysql user password is empty hit enter at prompt
---------------------------------------------
/mysqlbackup resides on partition which has
4.7G disk space available
---------------------------------------------
MySQL data directory located at: /var/lib/mysql/
MySQL data directory size in megabytes: 449
---------------------------------------------
!!!!!!!!!!!!!!!!!!!!!!!!! *** WARNING *** !!!!!!!!!!!!!!!!!!!!!!!!*** WARNING ***!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
 
[WARNING !!!] MySQL data directory size is larger than available disk space on /mysqlbackup
 
!!!!!!!!!!!!!!!!!!!!!!!!! *** WARNING *** !!!!!!!!!!!!!!!!!!!!!!!!*** WARNING ***!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
 
=========================================================
Checking to see if PV is installed...
=========================================================
 
PV (Pipe Viewer) already installed
continuing.....
 
Retrieving list of databases on server
if mysql user password is empty hit enter at prompt
 
Backing up database: [db2]
if mysql user password is empty hit enter at prompt
 483B 0:00:00 [57.6MB/s] [<=>                    ]
Successfully backed up database: db2
 
Backing up database: [db2] schema only
if mysql user password is empty hit enter at prompt
 
Backing up database: [mysql]
if mysql user password is empty hit enter at prompt
 153kB 0:00:00 [2.89MB/s] [<=>                   ]
Successfully backed up database: mysql
 
Backing up database: [mysql] schema only
if mysql user password is empty hit enter at prompt
 
Backing up database: [sbtest]
if mysql user password is empty hit enter at prompt
 134MB 0:00:08 [16.3MB/s] [   <=>                ]
Successfully backed up database: sbtest
 
Backing up database: [sbtest] schema only
if mysql user password is empty hit enter at prompt
 
*******************************************************
MySQL database backups at: /mysqlbackup/mysqlsql
*******************************************************
 
Jun 25  18:27   153K   mysql.localhost.localdomain.25-06-2011-182750.gz
Jun 25  18:27   483    db2.localhost.localdomain.25-06-2011-182750.gz
Jun 25  18:27   4.0K   ..
Jun 25  18:27   134M   sbtest.localhost.localdomain.25-06-2011-182750.gz
Jun 25  18:29   483    db2.localhost.localdomain.25-06-2011-182945.gz
Jun 25  18:29   153K   mysql.localhost.localdomain.25-06-2011-182945.gz
Jun 25  18:29   4.0K   .
Jun 25  18:29   134M   sbtest.localhost.localdomain.25-06-2011-182945.gz
 
*******************************************************
MySQL database schema only backups at: /mysqlbackup/mysqlschema
*******************************************************
 
Jun 25  18:27   23K    mysql.localhost.localdomain.25-06-2011-182750-schemanodata.sql
Jun 25  18:27   1.3K   db2.localhost.localdomain.25-06-2011-182750-schemanodata.sql
Jun 25  18:27   4.0K   ..
Jun 25  18:27   1.8K   sbtest.localhost.localdomain.25-06-2011-182750-schemanodata.sql
Jun 25  18:29   1.3K   db2.localhost.localdomain.25-06-2011-182945-schemanodata.sql
Jun 25  18:29   23K    mysql.localhost.localdomain.25-06-2011-182945-schemanodata.sql
Jun 25  18:29   1.8K   sbtest.localhost.localdomain.25-06-2011-182945-schemanodata.sql
Jun 25  18:29   4.0K   .
 
...
Backup Completed...
 
Time:
********************************
================================
Sat Jun 25 18:29:59 EST 2011
================================
********************************