我正在使用MySQL数据库上的ZRM服务器恢复增量备份。 我在表中有blob数据。 增量备份没有得到恢复，给mysql错误unknown command '\0' 。
试图改变max_allowed_packet_size为1 GB，也得到了问题。 检查ZRMconfiguration添加 – hex-blob但没有用。
使用–verbose恢复备份后出错：
restore:INFO: ZRM for MySQL Community Edition - version 2.2.0 restore:INFO: Reading options from file /etc/mysql-zrm/mysql-zrm.conf BackupSet1:restore:WARNING: Could not open file /etc/mysql-zrm/BackupSet1/last_backup. No such file or directory BackupSet1:restore:INFO: Using /usr/share/mysql-zrm/plugins/ssh-copy.pl as the default plugin since copy-plugin has not been specified BackupSet1:restore:INFO: ZRM Temporary configuration file = /etc/mysql-zrm/BackupSet1/tmpewWlH.conf BackupSet1:restore:INFO: { BackupSet1:restore:INFO: backup-level=0 BackupSet1:restore:INFO: destination=/mysql_backup/mysql-zrm BackupSet1:restore:INFO: databases=main BackupSet1:restore:INFO: source-directory=/mysql_backup/mysql-zrm/DailyBackup_SSH/20130212170902 BackupSet1:restore:INFO: mail-policy=always BackupSet1:restore:INFO: backup-mode=raw BackupSet1:restore:INFO: password=****** BackupSet1:restore:INFO: backup-type=regular BackupSet1:restore:INFO: copy-plugin=/usr/share/mysql-zrm/plugins/ssh-copy.pl BackupSet1:restore:INFO: } BackupSet1:restore:INFO: Getting mysql variables BackupSet1:restore:INFO: mysqladmin --password="*****" variables BackupSet1:restore:INFO: datadir is /var/lib/mysql/ BackupSet1:restore:INFO: mysql_version is 5.5.20-log BackupSet1:restore:INFO: InnoDB data file are /var/lib/mysql/ibdata1 BackupSet1:restore:INFO: InnoDB log dir is /var/lib/mysql/. BackupSet1:restore:INFO: Command used is 'cat "/mysql_backup/mysql-zrm/DailyBackup_SSH/20130212170902/backup-data" | "/usr/share/mysql-zrm/plugins/encrypt.pl" -d | "/usr/bin/gzip" -d | tar --same-owner -xpsC "/mysql_backup/mysql-zrm/DailyBackup_SSH/20130212170902" 2>/tmp/gIJmM6bLwF' BackupSet1:restore:INFO: Executing pre-restore-plugin BackupSet1:restore:INFO: BINLOG = mysqlbinlog --password="*****" --database=main "/mysql_backup/mysql-zrm/DailyBackup_SSH/20130212170902"/mysql-bin.[0-9]* >> /tmp/nADdF9OfBn BackupSet1:restore:INFO: Restoring incremental to file BackupSet1:restore:INFO: mysqlbinlog --password="*****" --database=main "/mysql_backup/mysql-zrm/DailyBackup_SSH/20130212170902"/mysql-bin.[0-9]* >> /tmp/nADdF9OfBn BackupSet1:restore:INFO: restoring using command mysql --password="*****" -e "source /tmp/nADdF9OfBn;" BackupSet1:restore:ERROR: Output of command: 'mysql --password="*****" -e "source /tmp/nADdF9OfBn;"' is { ERROR at line 202087 in file: '/tmp/nADdF9OfBn': `Unknown command '\0'`. } ERROR: Incremental restore failed BackupSet1:restore:ERROR: Incremental restore failed BackupSet1:restore:INFO: Removing all of the uncompressed/unencrypted data BackupSet1:restore:INFO: Executing post-restore-plugin BackupSet1:restore:ERROR: Restore failed
任何build议，非常感谢和提前感谢。
我们没有得到任何解决scheme来恢复采取BLOB数据备份导致Unknown command错误。 为了避免这种恢复错误，我们在mysql-zrm.conf文件中添加了extra-mysqldump-options="--hex-blob --skip-extended-insert" 。
希望这可以帮助别人！