Jump to content

Recover-dump

From Wikitech
(Redirected from Recover dump.py)
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

recover-dump allows the recovery of a database dump (logical backup) as described on MariaDB/Backups#Recovering_a_logical_backup:

usage: recover-dump [-h] [--host HOST] [--port PORT] [--threads THREADS]
                       [--user USER] [--password PASSWORD] [--socket SOCKET]
                       [--database DATABASE] [--replicate]
                       section

Recover a logical backup

positional arguments:
  section              Section name or absolute path of the directory to
                       recover("s3", "/srv/backups/archive/dump.s3.2022-11-12
                       --19-05-35") 

optional arguments:
  -h, --help           show this help message and exit
  --host HOST          Host to recover to
  --port PORT          Port to recover to
  --threads THREADS    Maximum number of threads to use for recovery
  --user USER          User to connect for recovery
  --password PASSWORD  Password to recover
  --socket SOCKET      Socket to recover to
  --database DATABASE  Only recover this database
  --replicate          Enable binlog on import, for imports to a master that
                       have to be replicated (but makes load slower).By
                       default, binlog writes are disabled.