PDA

View Full Version : DB Excluded in backup, but looked for in level 1 recovery



gloria
February 22nd, 2011, 11:45 PM
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.

paddy
February 23rd, 2011, 02:21 PM
MySQL server binary logs contain all changes to all databases.

Are you restoring backups to a specific database?

gloria
February 23rd, 2011, 11: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.







MySQL server binary logs contain all changes to all databases.

Are you restoring backups to a specific database?

gloria
February 25th, 2011, 03: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.