Results 1 to 5 of 5

Thread: Restore the backup to a sql file

  1. #1

    Default Restore the backup to a sql file

    Hi,

    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 ?

    Thanks,

  2. #2
    Join Date
    Feb 2014
    Location
    Noida
    Posts
    1

    Default

    I also have same problem.

  3. #3

    Default

    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/

  4. #4
    Join Date
    Feb 2015
    Posts
    1

    Default

    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]http://www.hartford.edu[/url]
    [url=http://www.certkiller.com/ ]http://certkiller.com[/url]
    [url]http://www.lynn.edu/[/url]
    [url]http://www.certkiller.com/exam-300-115.htm[/url]
    Last edited by Kazuya07; March 2nd, 2015 at 01:50 AM.

  5. #5

    Default

    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
  •