Results 1 to 7 of 7

Thread: manual backup

  1. #1

    Default manual backup

    Is it possible to make manual restore from the backup taken by ZRM

  2. #2
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    Yes you can. You can use mysql-zrm-restore. If you want to do restoration without ZRM, you can easily do so from logical backups. Other backup methods are more complex.

    Please provide more details.

  3. #3

    Default manual restore

    I want to restore a database that has been backed up by ZRM where backup-mode=logical but the thing is.... I want to restore it manually just by mysql commands not by ZRM restore command... In this situation what is the procedure....

    Does ZRM make any *.sql file while logical backup?

  4. #4
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    For logical backups, ZRM creates *.sql file in /var/lib/mysql-zrm/// directory. You should be able to pass it to mysql command directly.

    If you have compressed or encrypted it, please uncompress/decrypt before passing it on to mysql command.

    Paddy

  5. #5

    Default

    Thanks for your reply

    Can you guide how to uncompress/decrypt that file and which one has to do 1st uncompress or decrypt.

    Raja
    Last edited by linux123; July 10th, 2009 at 06:49 AM.

  6. #6
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    Quote Originally Posted by linux123 View Post
    Thanks for your reply

    Can you guide how to uncompress/decrypt that file and which one has to do 1st uncompress or decrypt.

    Raja
    If you are using default methods, use gpg to decrypt (See /usr/share/mysql-zrm/plugins/encrypt-plugin.pl) and then use gunzip to
    uncompress the file.

    Paddy

  7. #7

    Default

    Thanx paddy for your reply let me check it.

    -Raja

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
  •