June 4th, 2014, 11:30 AM
Restore the backup to a sql file
When I checked in the backup location, I can see the following files :
backup-data index zrm_checksum
Is there any way to create a sql file from these and use it for restore ?
Normally I restore the databases as :
mysql-zrm-restore --host *.*.*.* --tmpdir /mnt_backup/tmp --backup-set myserver.com --source-directory /backup/sql/myserver.com/20140603050029 --user user_name --password pass_word
Now,I want to create database backup as something.sql which contains the backup that can be used to restore the databases later to the server. Is that possible ?
June 4th, 2014, 09:17 PM
I also have same problem.
October 20th, 2014, 04:29 AM
I see this forum less active than others. I can see no replies to our posts even after days. Nevertheless, you can use the below commands to create a mysql backup
1. locate the backup using the below command :
mysql-zrm-reporter --show restore-info --where backup-set=myhostserver1.com
where 'myhostserver1.com' is my host configured for backup
2. Extract the backup to the location /backup/sql/myhostserver1.com/20140604050029/
mysql-zrm-extract-backup --source-directory /backup/sql/myhostserver1.com/20140604050029/ --tmpdir /temporary_location/
February 15th, 2015, 10:16 PM
After upgrading a machine my snapshot/ssh-copy based raw backups fail. I have confirmed the mysql uid/gids are uniform, rsa keys are shared and working, all of the zrm plugins including the socket server are owned by mysql.mysql. I've been working on this for 3 days and our backups are stale. I've had zrm running for years and have never encountered this.
Last edited by Kazuya07; March 2nd, 2015 at 01:50 AM.
March 21st, 2015, 02:43 AM
Tags for this Thread