Zrm version: ZRM for MySQL Community Edition - version 3.0
Mysql version: 5.6.15-log MySQL Community Server
OS: Red Hat Enterprise Linux Server release 6.5 (Santiago)

Running a backup for our database appears to work fine, no errors are printed and using mysql-zrm-list and mysql-zrm-reporter shows that the backups should be valid. When we try to simply drop the database and restore from the backup, again there appaears to be no issues and the utility reports as successful but the missing database is not actually retrieved.

Code:
---------------------------------------------------------Test database and table date

[root@bennett db]# mysql -u root -p
Server version: 5.6.15-log MySQL Community Server (GPL)
mysql> CREATE DATABASE dba_test;
mysql> CREATE TABLE test_recovery(ID INT,LETTER CHAR);
mysql> INSERT INTO test_recovery (ID,LETTER) VALUES (1,'A'),(2,'B'),(3,'C'),(4,'D');
Query OK, 4 rows affected (0.02 sec)
Records: 4  Duplicates: 0  Warnings: 0
--------------------------------------------------------Run mysql-zrm backup

[root@bennett db]# mysql-zrm --action backup --backup-set bennett-all --backup-level 0
backup:INFO: ZRM for MySQL Community Edition - version 3.0
bennett-all:backup:INFO: START OF BACKUP
bennett-all:backup:INFO: PHASE START: Initialization
bennett-all:backup:INFO: The quick backup-type is supported only for snapshot backups. Setting backup-type to 'regular'
bennett-all:backup:INFO: backup-set=bennett-all
bennett-all:backup:INFO: backup-date=20161129121237
bennett-all:backup:INFO: mysql-server-os=Linux/Unix
bennett-all:backup:INFO: backup-type=regular
bennett-all:backup:INFO: host=localhost
bennett-all:backup:INFO: backup-date-epoch=1480421557
bennett-all:backup:INFO: retention-policy=10D
bennett-all:backup:INFO: mysql-zrm-version=ZRM for MySQL Community Edition - version 3.0
bennett-all:backup:INFO: mysql-version=5.6.15-log
bennett-all:backup:INFO: backup-directory=/dbbackup/zrm-backup/bennett-all/20161129121237
bennett-all:backup:INFO: comment=bennett-all backup
bennett-all:backup:INFO: backup-level=0
bennett-all:backup:INFO: backup-mode=logical
bennett-all:backup:INFO: PHASE END: Initialization
bennett-all:backup:INFO: PHASE START: Running pre backup plugin
bennett-all:backup:INFO: PHASE END: Running pre backup plugin
bennett-all:backup:INFO: PHASE START: Flushing logs
Warning: Using a password on the command line interface can be insecure.
bennett-all:backup:INFO: PHASE END: Flushing logs
bennett-all:backup:INFO: PHASE START: Creating logical backup
bennett-all:backup:INFO: Command exit status is : 0
bennett-all:backup:INFO: Output of command: 'mysqldump output for command : bash -c 'mysqldump --opt --extended-insert --create-options --default-character-set=utf8 --routines --single-transaction --user="zrm-backup" --password="*****" --host="localhost" --all-databases  > "/dbbackup/zrm-backup/bennett-all/20161129121237/backup.sql" 2>>/tmp/pqtXDsrx3S;echo ${PIPESTATUS[@]} > /tmp/xhRAHb8Eqw 2>>/tmp/pqtXDsrx3S'' is {
Warning: Using a password on the command line interface can be insecure.
 mysqldump: Couldn't execute 'show create table `ACTIVE_EXCEPTIONS`': SHOW VIEW command denied to user 'zrm-backup'@'localhost' for table 'ACTIVE_EXCEPTIONS' (1142)
}
bennett-all:backup:INFO: logical-databases=D_DATAHEALTH D_DATAPROVIDER D_ESBOA dba_test #mysql50#lost+found mysql performance_schema tmpdb
logical-parallel=0
bennett-all:backup:INFO: PHASE END: Creating logical backup
bennett-all:backup:INFO: PHASE START: Calculating backup size & checksums
bennett-all:backup:INFO: next-binlog=mysql-bin.000900
bennett-all:backup:INFO: last-backup=/dbbackup/zrm-backup/bennett-all/20161129113803
bennett-all:backup:INFO: backup-size=808.33 MB
bennett-all:backup:INFO: PHASE END: Calculating backup size & checksums
bennett-all:backup:INFO: PHASE START: Compression/Encryption
bennett-all:backup:INFO: compress=
bennett-all:backup:INFO: backup-size-compressed=115.18 MB
bennett-all:backup:INFO: PHASE END: Compression/Encryption
bennett-all:backup:INFO: read-locks-time=00:01:20
bennett-all:backup:INFO: flush-logs-time=00:00:00
bennett-all:backup:INFO: compress-encrypt-time=00:59:40
bennett-all:backup:INFO: backup-time=00:01:55
bennett-all:backup:INFO: backup-status=Backup succeeded
bennett-all:backup:INFO: Backup succeeded
bennett-all:backup:INFO: PHASE START: Running post backup plugin
bennett-all:backup:INFO: PHASE END: Running post backup plugin
bennett-all:backup:INFO: PHASE START: Cleanup
bennett-all:backup:INFO: PHASE END: Cleanup
bennett-all:backup:INFO: END OF BACKUP

--------------------------------------------------------Did it work?

[root@bennett db]# mysql-zrm-reporter --where backup-set=bennett-all --show backup-     status-info
REPORT TYPE : backup-status-info

          backup_set  backup_date                  backup_level  backup_status         backup_type       comment
-----------------------------------------------------------------------------------------------------------------------------
         bennett-all  Tue 29 Nov 2016 12:12:37                0  Backup succeeded      regular           bennett-all backup
                      PM GMT

--------------------------------------------------------Drop databases
mysql> drop database dba_test;

mysql> show databases;
+---------------------+
| Database                 |
+---------------------+
| information_schema   |
| D_DATAHEALTH        |
| D_DATAPROVIDER     |
| D_ESBOA                 |
| #mysql50#lost+found |
| mysql                      |
| performance_schema |
| tmpdb                     |
+---------------------+

--------------------------------------------------------Restore dba_test database
[root@bennett db]# mysql-zrm --action restore --backup-set bennett-all --source-directory /dbbackup/zrm-backup/bennett-all/20161129121237/ --databases "dba_test" --verbose
restore:INFO: ZRM for MySQL Community Edition - version 3.0
restore:INFO: Reading options from file /etc/mysql-zrm/mysql-zrm.conf
bennett-all:restore:INFO: Reading options from file /etc/mysql-zrm/bennett-all/mysql-zrm.conf
bennett-all:restore:INFO: The quick backup-type is supported only for snapshot backups. Setting backup-type to 'regular'
bennett-all:restore:INFO: Mail address: ITDBA@gbgplc.co.uk is ok
bennett-all:restore:INFO: ZRM Temporary configuration file = /etc/mysql-zrm/bennett-all/tmpKNbY4.conf
bennett-all:restore:INFO: {
bennett-all:restore:INFO:       retention-policy=10D
bennett-all:restore:INFO:       all-databases=1
bennett-all:restore:INFO:       destination=/dbbackup/zrm-backup/
bennett-all:restore:INFO:       source-directory=/dbbackup/zrm-backup/bennett-all/20161129121237/
bennett-all:restore:INFO:       routines=1
bennett-all:restore:INFO:       password=******
bennett-all:restore:INFO:       backup-mode=logical
bennett-all:restore:INFO:       backup-type=regular
bennett-all:restore:INFO:       user=zrm-backup
bennett-all:restore:INFO:       backup-level=0
bennett-all:restore:INFO:       mailto=ITDBA@gbgplc.co.uk
bennett-all:restore:INFO:       databases=dba_test
bennett-all:restore:INFO:       host=localhost
bennett-all:restore:INFO:       mail-policy=only-on-error
bennett-all:restore:INFO:       comment=bennett-all backup
bennett-all:restore:INFO:       compress=
bennett-all:restore:INFO: }
bennett-all:restore:INFO: Getting mysql variables
bennett-all:restore:INFO: mysqladmin --user="zrm-backup" --password="*****" --host="localhost" variables
bennett-all:restore:INFO: datadir is /db/
bennett-all:restore:INFO: mysql_version is 5.6.15-log
bennett-all:restore:INFO: Command used is 'cat "/dbbackup/zrm-backup/bennett-all/20161129121237/backup-data"  |  gzip -d  | tar  --same-owner -xpsC  "/dbbackup/zrm-backup/bennett-all/20161129121237/"  2>/tmp/LlSaimFdbK'
bennett-all:restore:INFO: Executing pre-restore-plugin
bennett-all:restore:INFO: restoring using command mysql --user="zrm-backup" --password="*****" --host="localhost" -e "set character_set_client=utf8;set character_set_connection=utf8;set character_set_database=utf8;set character_set_results=utf8;set character_set_server=utf8;source /tmp/kIGTH1eSRz;"
Warning: Using a password on the command line interface can be insecure.
bennett-all:restore:INFO: Restored database(s) from logical backup:  dba_test
bennett-all:restore:INFO: Removing all of the uncompressed/unencrypted data
bennett-all:restore:INFO: Executing post-restore-plugin
bennett-all:restore:INFO: Restore done in 14 seconds.

--------------------------------------------------------Did it work?

mysql> show databases;
+---------------------+
| Database                 |
+---------------------+
| information_schema   |
| D_DATAHEALTH        |
| D_DATAPROVIDER     |
| D_ESBOA                 |
| #mysql50#lost+found |
| mysql                      |
| performance_schema |
| tmpdb                     |
+---------------------+