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
Comments not found