msrestore

msrestore is a mysql-zrm remote restore tool that supports restoring to a particular timestamp.

Installation

pip install msrestore

Usage

usage: msrestore [-h] [-v] [--user USER] [--password PASSWORD]
 [--backupset BACKUPSET] [--timestamp TIMESTAMP]
 host database

Restore MySQL backups.

positional arguments:
 host host string to restore from
 database database to restore from/to

optional arguments:
 -h, --help show this help message and exit
 -v, --verbose print detailed output
 --user USER local MySQL user
 --password PASSWORD local MySQL password
 --backupset BACKUPSET
 ZRM backup set to restore from, defaults to
 database capitalized
 --timestamp TIMESTAMP
 timestamp to restore DB state from

Examples

Restore the remote DB 'derp' from the host 'herp'. Assumes that the backup set is named Derp.

 msrestore scott@herp derp

Restore the same DB to 01/14/2012 at midnight.

 msrestore scott@herp derp --timestamp 20120114000000

Requirements:

• Python