PDA

View Full Version : Restoring a single record?



jmartin235
September 19th, 2008, 07:22 AM
Hello! I got the community edition of ZRM a few days ago and have been trying it out. A co-worker posed an interesting question - how do you restore a single record? For instance, a record gets deleted at an unknown time, and it's needed today. What's the easiest way to search and restore it?

Thanks!

paddy
September 19th, 2008, 02:25 PM
Hello! I got the community edition of ZRM a few days ago and have been trying it out. A co-worker posed an interesting question - how do you restore a single record? For instance, a record gets deleted at an unknown time, and it's needed today. What's the easiest way to search and restore it?

Thanks!

You can use ZRM enterprise edition (http://www.zmanda.com/zrm-mysql-enterprise.html) that provides web based UI to search and restore database events.

You can do it in command line (searching is complicated) in the community edition.
See http://mysqlbackup.zmanda.com/index.php/Selective_Recovery#Selective_Restoration_of_Databa se_Events

Paddy