Results 1 to 4 of 4

Thread: DB Excluded in backup, but looked for in level 1 recovery

  1. #1

    Default DB Excluded in backup, but looked for in level 1 recovery

    Hi all.

    I'm using ZRM for MySQL Community Edition - version 2.2.0.
    I have a level 0 backup every Friday and level 1 backups the rest of
    the week. In the configuration file I have the parameter
    exclude-pattern=test|saltweb

    I restore the level 0 backup and everything goes fine and, of course,
    saltweb database doesn't appear. But if I try to apply the level 1 copy
    I have the next error:
    ERROR 1146 (42S02) at line 7725 in file: '/tmp/RGHcHadlZU': Table 'saltweb.salttrad_coms' doesn't exist
    }

    Why is looking for the saltweb DB? How can I skip it?

    I execute the same backup-set in level 0 and level 1 backup.


    Regards.

  2. #2

    Default

    MySQL server binary logs contain all changes to all databases.

    Are you restoring backups to a specific database?

  3. #3

    Default

    No, I don't restore a specific database. I want to restore all the databases
    backed up. Do I have to specify the databases one by one?
    I thought that Amanda could do it.






    Quote Originally Posted by paddy View Post
    MySQL server binary logs contain all changes to all databases.

    Are you restoring backups to a specific database?
    Last edited by gloria; February 23rd, 2011 at 11:20 PM.

  4. #4

    Default

    I used the mysqlbinlog to workaround the problem. I hope ZRM lets choose the
    databases to restore in a level 1 recovery in the future.

Posting Permissions

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