Template:SQWareProduction sqwmys CopyXtraBackup.ksh help

From Wiki_dbSQWare
Revision as of 17:14, 20 May 2025 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to navigation Jump to search
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.
Sourcing sqwmys_Global.lib v2025.05 SQWareProduction for MySQL (dbSQWare) ... 

Usage: sqwmys_CopyXtraBackup.ksh [[-h]] -I instance -T <type> -IS <SourceInstance> -US <SourceHostname> [[+ options]]

DESCRIPTION
   sqwmys_CopyXtraBackup.ksh copy of XtraBackup $lvsqw_CopyType 
SUPPORT
   MariaDB supported versions: 5.5 <= v <= 11.4

PARAMETERS
     -I  instance       : Target instance to copy.
     -T  type           : Which backup to copy:
                           - LastFull => copy the last full backup
                           - LastInc  => copy the last incremental backup
                           - <tag>    => copy this backup tag (part of file name)
     [
     -GetInf  u@h:path  : user@host:path to retrieve XtraBackup from distant source.
     OR
     -PutInf  u@h:path  : user@host:path to push XtraBackup to distant host.
     OR
     -IS instance       : Source instance.
     -US hostname       : Source hostname.
     ]
OPTIONS
     -h                 : Display the full usage.
     -s                 : Display samples of usage.
     -P  Nb processes   : Max number of processes (by default 2).
     -NoMail            : Deactivate sendmail on error demo-sqwarebox@dbsqware.com (by default, send on error).
     -F  file           : XtraBackup dir to copy (by default take the latest).
     -HI Nb             : Nb of generations to keep, only for get option (by default 1).
     -RD  directory     : Local directory to get or put XtraBackup dir (by default $HOME/XtraBackup/$MYSQL_SID).
     -RDS directory     : Distant directory to get or put XtraBackup dir (by default $HOME/XtraBackup/$lvsqw_InstanceSource).
     -UUS     username  : Source unix user(by default, same as target).
     -Before scriptname : Script to execute before copy XtraBackup.
     -After  scriptname : Script to execute after copy XtraBackup.
     -AddMail   email   : Email address to add at 'demo-sqwarebox@dbsqware.com'.
     -SendReport        : Send execution log report.
     -Locale    locale  : Force Locale for help display (fr,en).
     -AGR Nb_sec        : Nb of seconds between two runs (by default 10s).
     -AGE Nb_sec        : Nb of seconds between two checks of end (by default 30s).
     -Exec              : Copy dir $lvsqw_CopyType (by default, display generated commands).