Results 1 to 5 of 5

Thread: Restore the backup to a sql file

  1. #1

    Default 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 --source-directory /backup/sql/ --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 ?


  2. #2
    Join Date
    Feb 2014


    I also have same problem.

  3. #3


    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
    where '' is my host configured for backup
    2. Extract the backup to the location /backup/sql/
    mysql-zrm-extract-backup --source-directory /backup/sql/ --tmpdir /temporary_location/

  4. #4
    Join Date
    Feb 2015


    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.

    [url= ][/url]
    Last edited by Kazuya07; March 2nd, 2015 at 01:50 AM.

  5. #5


    nice tips... thank you

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts