mxrestore

1 Description

mxrestore is used to restore data backed up using the mxbackup tool.

2 Parameter Options

Parameter name	Description
--backup-dir directory	Absolute path to backup data that needs to be restored.
--create-db	Create the database before recovering the data.
--data-only	Only restore data, not meta information.
--debug	Output log information at the debug level.
--exclude-schema schema	Schema excluded when recovering. This parameter can be specified by using multiple times.
--exclude-schema-file file	A list of schemas that need to be excluded.
--exclude-table table	Table excluded during recovery. This parameter can be used multiple times to specify multiple tables.
--exclude-table-file file	A list file containing tables to be excluded.
--help	Show help information.
--include-schema schema	Specify the schema that needs to be restored. You can specify multiple schemas through multiple use.
--include-schema-file file	Specify the schema list file that needs to be restored.
--include-table table	Specify the table to be restored. Multiple tables can be specified by using them multiple times.
--include-table-file file	Specify a list file containing the tables to be restored.
--incremental	Incremental recovery, suitable for AO tables.
--jobs num	The number of concurrent connections during recovery, default is 1.
--metadata-only	Only restore metadata, not data in tables.
--on-error-continue	Recover logs and continues when an error is encountered.
--plugin-config file	Specify the location of the plug-in configuration file.
--quiet	Do not display all non-alarm or non-error log information.
--redirect-db db	Restore data to the specified database, not the database used when backing up.
--redirect-schema schema	Restore data to the specified schema, not the schema used during backup.
--run-analyze	Run ANALYZE on the recovered table.
--timestamp timestamp	The timestamp that needs to be used during recovery is in the format YYYYMMDDHHMMSS.
--truncate-table	Delete the recovered table data.
--verbose	Print detailed log information.
--version	Print the tool version number and exit.
--with-globals	Restore global metadata.
--with-stats	Recover statistics.

3 Examples

Restore the backup of the 20210820143820 timestamp in the /home/mxadmin/backup directory:

mxrestore --backup-dir /home/mxadmin/backup --timestamp 20210820143820