PDA

View Full Version : parsing encryted backup for restore



rkempf
December 4th, 2006, 11:01 AM
Hello,

I have just started recently using zmanda backup. I have a question about the encrypted backup.

Here is a little background on my setup. I am doing a full backup using gpg encryption and bzip on Sundays as well as daily incrementals also using gpg encryption and bzip.

I have to restore 2 rows out of either the full or an incremental and do not know how to parse the bzipped encypted backup-data file to find the 2 rows that need to be restored. In a regular mysql datadump I could grep the file and look for the 2 rows that need to be restored but am not sure about the encrypted file.

I would appreciate any help on this one.

Thanks in advance,

ReedK

paddy
December 4th, 2006, 11:14 AM
Hi ReedK,

Do you know which backup dates contains the two rows that you are looking for?

If you know the approximate date that has the information, you can use "parse-binlogs"
option of MySQL ZRM. You can even write a filter plugin that you can run against starting
from last full backup.

See the wiki for binary log parsing (http://mysqlbackup.zmanda.com/index.php/How_do_I_recover_data_when_there_is_a_failure_or_d ata_loss%3F#Browsing_MySQL_binary_logs) documentation and binary log parser plugin (http://mysqlbackup.zmanda.com/index.php/How_to_create_custom_plugins_for_MySQL_ZRM%3F#Bina ry_log_parser_plugin).

If you have questions, please post them.

Thanks,
Paddy

kkg
December 4th, 2006, 09:12 PM
Hi ReedK,

Do you know which backup dates contains the two rows that you are looking for?

If you know the approximate date that has the information, you can use "parse-binlogs"
option of MySQL ZRM. You can even write a filter plugin that you can run against starting
from last full backup.

See the wiki for binary log parsing (http://mysqlbackup.zmanda.com/index.php/How_do_I_recover_data_when_there_is_a_failure_or_d ata_loss%3F#Browsing_MySQL_binary_logs) documentation and binary log parser plugin (http://mysqlbackup.zmanda.com/index.php/How_to_create_custom_plugins_for_MySQL_ZRM%3F#Bina ry_log_parser_plugin).

If you have questions, please post them.

Thanks,
Paddy

Before you do the parse-logs you will probably want to do a
mysql-zrm --action extract-backup

This will unencrypt and untar the backup-data in the source directory.

Thanks,
--kkg