February 22nd, 2011, 10:45 PM
DB Excluded in backup, but looked for in level 1 recovery
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
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.
February 23rd, 2011, 01:21 PM
MySQL server binary logs contain all changes to all databases.
Are you restoring backups to a specific database?
February 23rd, 2011, 10:27 PM
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.
Originally Posted by paddy
Last edited by gloria; February 23rd, 2011 at 11:20 PM.
February 25th, 2011, 02:35 AM
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.